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
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"
Show quoted text
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 clientshi,
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?