too many clients - Error message

The maximum number of backends that the PostGres postmaster will start is
32. If you want more, you have to specify the maximum on the command line
with the -N option. IE, you can start postgres like this to allow internet
connections, have it fork into the background, and allow 100 simultaneous
connections:
/usr/local/pgsql/bin/postmaster -i -B 256 -S -N 100

At 07:16 AM 4/22/00, Joseph wrote:

Depends on what you are using for clients. For instance, many web
programming suites use "persistent connections." Persistent connections
stay open in the hopes that the web server process will have need of them
again, and keeping them open will save the time of reconnecting when that
occurs. Only Apache with addons like mod_perl, Zope, or PHP will use
persistent connections. In other clients, I would guess that the problem
is that the client isn't calling disconnect, either because it's idling, or
because the author forgot to code it in before the client exits. I'm not
sure how long it takes PostGres to idle out a backend process, or if it
ever will.

At 07:31 AM 4/26/00, Joseph wrote: