Thread: Increasing connection limit in postgres

Increasing connection limit in postgres

From
Akash Garg
Date:
How do you recompile postgres to allow more than 1024 connections?

Thanks,
Akash

Re: Increasing connection limit in postgres

From
Tom Lane
Date:
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

Re: Increasing connection limit in postgres

From
"Thomas F. O'Connell"
Date:
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:

> How do you recompile postgres to allow more than 1024 connections?
>
> Thanks,
> Akash