Re: Increasing number of postgres 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(at)sona(dot)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.