Re: Maximum number of client connection supported by Postgres 8.4.6

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(dot)albe(at)wien(dot)gv(dot)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
>