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.a...@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 >
