Thread: Increasing number of postgres connections

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

Thanks,
Akash

On Mon, May 16, 2005 at 11:42:13AM -0700,
 Akash Garg <akash@sona.com> wrote
 a message of 12 lines which said:

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

Do you really need to recompile? I find in the man page:

       -N max-connections
              Sets the maximum number of client connections that this postmas-
              ter will accept. By default, this value is 32, but it can be set
              as high as your system will support. (Note that -B  is  required
              to  be at least twice -N. See the section called ``Managing Ker-
              nel Resources'' in the documentation for a discussion of  system
              resource  requirements for large numbers of client connections.)

On Tue, 2005-05-17 at 09:38, Stephane Bortzmeyer wrote:
> On Mon, May 16, 2005 at 11:42:13AM -0700,
>  Akash Garg <akash@sona.com> wrote
>  a message of 12 lines which said:
>
> > How do you recompile postgres to allow more than 1024 connections?
>
> Do you really need to recompile? I find in the man page:
>
>        -N max-connections
>               Sets the maximum number of client connections that this postmas-
>               ter will accept. By default, this value is 32, but it can be set
>               as high as your system will support. (Note that -B  is  required
>               to  be at least twice -N. See the section called ``Managing Ker-
>               nel Resources'' in the documentation for a discussion of  system
>               resource  requirements for large numbers of client connections.)


As Tom pointed out yesterday, this limitation was removed several
versions ago.  Upgrading is probably a much better option.