Increasing number of postgres connections

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.