Increasing connection limit in postgres

Akash Garg <akash.garg@gmail.com> writes:

How do you recompile postgres to allow more than 1024 connections?

If you are using any remotely modern version of Postgres, there isn't
any specific compile-time limit on that. So I think the correct
answer is "upgrade".

regards, tom lane

There should be no need to recompile anything. See the entry for
max_connections:

http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-
CONFIG-CONNECTION

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On May 16, 2005, at 1:44 PM, Akash Garg wrote: