Typically you won't get that error until you have about 32 concurrent
backends (default configuration). There are many possibilities:
1) backends are being spawned but not reaped. When this problem starts
happening have you checked to see how many postgres processes are running?
2) There aren't enough system resources to launch additional backends
3) What is your -N value when invoking postmaster? Do you have a suitable -B
value (twice or more -N)
4) Is postgres logging anything to syslog?
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: Thirumoorthy Bhuvneswari <tbhuvneswari@yahoo.com>
> Date: Tue, 2 Oct 2001 06:09:26 -0700 (PDT)
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Using Postgresql-7.0.1 in multiple clients
>
> hi,
> I am new to this mailing-list though I have been using
> postgresql for sometime. We are using a database
> server connected with some clients. We have made sure
> that the 'Postmaster' is running always from the
> System startup.
> We are using Postresql-7.0.1 and getting database
> disconnected frequently. When 2 to 3 clients starts
> using the database simultaneously, database gets
> disconnected with an Exception "Sorry, too many
> clients already"(in JDBC). Isn't possible more clients
> to use Postgres database. Is it a bug? Please help me.
> Thank u in advance.
> bhuvaneswari.t
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
