Hi All,
Exact Error Message is as follow..
[ERROR] Error getting DB connection: The connection attempt failed.
[ERROR] Action commit error: Out of database connections.
This is the output I am getting form application server, On database end I am getting nothing.
plz suggest.
If possible guide me how to calculate max_connections based on available hardware.
Thanks & regards,
JENISH VYAS
On Thu, Jul 21, 2011 at 4:28 PM, Albe Laurenz
<laurenz.albe@wien.gv.at> wrote:
Jenish Vyaswrote:
> please let me know what is the maximum number of concurrent client
connection supported by Postgres
> 8.4.6
>
> max_connections = ????
>
> For my database,
>
> If I am running the test for more then 1000 concurrent active user it
is showing me error "running out
> of connection"
>
> I have set max_connections = 1200.
There is no error message "running out of connection" in the code base.
Could you quote the exact message?
Maybe you are hitting a kernel resource limit, see
http://www.postgresql.org/docs/8.4/static/kernel-resources.html
In that case you might have to increase SEMMNS or SEMMNI.
Yours,
Laurenz Albe