Forum OpenACS Q&A: Postgres connections and OpenACS

Collapse
Posted by Malte Sussdorff on
We had a *very* interesting experience today due to our starting usage of POUND.

Two webservers, both configured to have 60 database connections.

One database, configured to have 100 maxconnections.

THe site stopped (no replies anymore) on a regular basis and we had no clue what has happened, until we shut down one of the two webservers and then everything went smoothly.

What I am saying is this, and maybe we are just very very unlucky ...

If you run multiple webservers in front of your database make sure that you do not exceed the maxconnections of the database. Otherwise you webservers will freeze as they try to get a new connection, the new connection is not granted and for whatever the reason AOLserver / nspostgres waits for new connections instead of just reusing the old one :).

Collapse
Posted by Iuri Sampaio on
i'm far away to use this complexes schemes, but when i read that, came up the question...
what happen if you just increase the maxconnection number?

then you can adjust it and you will never exceed the maxconnections of the database :)
does it make any sense?