Re: Increasing number of postgres connections - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Increasing number of postgres connections
Date
Msg-id 1116341435.22291.115.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Increasing number of postgres connections  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Stephane Bortzmeyer
Date:
Subject: Re: Increasing number of postgres connections
Next
From: Tom Lane
Date:
Subject: Re: Writing a join selectivity function