Thread: max connection

max connection

From
Frédéric Liotino
Date:
Hello,
 
I have a problem when I launched simultaneous several connections, under more or less 50 connections I have a JDBC error : Backend start-up failed : FATAL : Sorry, too many clients already.
 
Please, How soluce this.
 
Thank you.
 
Liotino Frédéric

Re: max connection

From
"Nick Fankhauser"
Date:
In postgresql.conf, add the line MAX_CONNECTIONS = n, where n is the number
of simultaneous client connections you want. The default is 32. For details
see:

http://www.postgresql.org/docs/view.php?version=7.3&file=runtime-config.html

Also, if you have that many connections, you should consider using a
connection pool if you aren't already doing so.

-Nick


-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Frédéric Liotino
Sent: Wednesday, April 30, 2003 7:14 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] max connection


Hello,

I have a problem when I launched simultaneous several connections, under
more or less 50 connections I have a JDBC error : Backend start-up failed :
FATAL : Sorry, too many clients already.

Please, How soluce this.

Thank you.

Liotino Frédéric