Juan,
Look at the postmaster man page ('man postmaster') and look at
the -N switch. That controls the maximum number of backends that
can be started. The default is 32, which sounds consistent with your
problem.
--Jeremy
On Tuesday, October 30, 2001, at 02:14 AM, Juan José Antonio Lix wrote:
> Hello,
>
> I'm a it consultant and right now I'm involving in a Customer Care
> project.
> A month ago we decide to use a Linux platform to support the database
> server
> and adopt PostgreSQL as our database server. Last month we had the first
> testing "experience". We were trying to simulate 100 concurrent users,
> but
> when just 30 were connected we receive the following crash:
> "Something unusual has occured to cause the driver to fail. Please
> report
> this
> exception: java.sql.SQLException: Sorry, too many clients already
> at org.postgresql.Driver.connect(Driver.java:125)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at DbManager.connect(DbManager.java:35)
> at Hilo.<init>(TheFrame.java:242)
> at TheFrame.main(TheFrame.java:181)"
>
> If it means that PostgreSQL doesn't support more that 30 concurrent
> users
> unfortunately we would have to migrate our current development to
> another
> database server, such as MySQL or Oracle. But if, as I suppose, this is
> just
> a JDBC driver's bug we would like to know if another "free-bug" driver
> is
> available.
>
> This is critical for us, so please, reply me as soon as possible.
>
> Thank you,
> Juan José Antolínez
>
>
>
>
>
> _______________________________________________________
> http://inbox.excite.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
