Connections Limit

[stoolpigeon]

Is there a limit to the number of concurrent connections to a single database in postgresql?

 

[rycamor]

PostgreSQL's default setting supports only 32 concurrent connections, but that can easily be changed by editing postgresql.conf. There is a hard connection limit of 1024 concurrent connects. If you want more than that, you need to edit a line in one of the header files in the source code, and recompile PostgreSQL. (sorry, I don't remember which file it is) -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)

 

[stoolpigeon]

Thank you very much.