PostgreSQL 8.0.3 limiting max_connections to 64 ?

From: eu <alexandre(at)vectorx(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 8.0.3 limiting max_connections to 64 ?
Date: 2005-08-17 16:05:36
Message-ID: 43036050.2090903@vectorx.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, i need help...

i have a postgresql 8.0.3 database running on the backend of a postfix
setup ( i didn't trust Mysql for the job ) on Linux kernel 2.6.8.1,
serving email to a dozen different virtual domains ( including this one
i'm using right now )...

however, this setup takes a whole lot of simultaneous connections to the
database
( postfix, amavis-new, clamav + spamassassin, apache+squirrelmail,
courier-authlib and courier-imap ), all those services were configured
to use Unix Domain Sockets, instead of TCP ( netstat -anvp showed too
many short-lived connections were kept on CLOSE_WAIT for too long while
connecting via TCP ), and, despite i have made max_connections on the
postgresql.conf as high as 500, after ( around ) 64 simultaneous
connections i start having a lot of "sorry too many clients already"
errors on my postgresql logfile...
then, my users go nuts complaining about how slow the server is and/or
having to retype their passwords too many times ( of course, since
authlib can't pick a connection to authenticate against the database ).

max_connections, shared_buffers, shmmax were tweaked, but the server
does not seems to respect the 500 max_connections...
i *know* i'm missing something obvious, but, what could be wrong ?...
i'm lost... any help would be most appreciated... please.

thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2005-08-17 16:10:56 Re: Finding nearest numeric value
Previous Message Tom Lane 2005-08-17 16:04:23 Re: Finding nearest numeric value