By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Too many clients already

P: 13
When connecting to postgresql datbase server, it says to many clients already. So what is the solution of this problem? and how can we view the client connections.
Thanks,
Ntech
Jul 29 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
The maximum number of connections can be specified by either providing the -N max-connections option to the postmaster or (the preferable approach) by specifying this parameter in postgresql.conf
Look at these links for more information
server configuration
http://www.postgresql.org/docs/8.1/i...AX-CONNECTIONS
http://www.postgresql.org/docs/8.1/i...SHARED-BUFFERS

To see the current limit you can run this query:
Expand|Select|Wrap|Line Numbers
  1. show max_connections;
  2.  
To see how many concurrent connections are there you can use the statistic collector

Try this query:
Expand|Select|Wrap|Line Numbers
  1. select datname as "database name", count(*) as "current connections" 
  2. from pg_stat_activity group by datname;
  3.  
Jul 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.