Re: Max Conncection limit?

On Tue, Mar 13, 2001 at 11:33:10AM -0500, Najm Hashmi wrote:
> We start a server and initiate 30 connections(with the libpq C interface)
> which are stored in a stack to use and and to be reused.
>
> After awhile I try to start another server that will also try to initiate 30
> connections, for each connection I then get a PQErrorMessage like that :
> "Sorry, too many connections"
>
> if I do a ps -ax at that time I get a lot of /usr/bin/postgres 192.168.0.1
> user name passwd idle
>
> what I usually do is restart postgres but I wish I didnt have to do that...
> That is not an elegant solutuion any ways.
> What can I do? Thanks in advance. Regards

Have a look at the runtime-config.html in the admin section of the
manual:

MAX_CONNECTIONS (integer)

Determines how many concurrent connections the database server will
allow. The default is 32. There is also a compiled-in hard upper limit
on this value, which is typically 1024 (both numbers can be altered when
compiling the server). This parameter can only be set at server start.

Regards, Frank