Max connections

On Tue, 2002-11-12 at 14:30, Williams, Travis L, NPONS wrote:

To change the max connections I'm assuming I need to edit the postgresql.conf file and change this line:
#max_connections = 32
to something like
max_connections = 64

I do need to uncomment this correct? Is there anything else I need to change?

That should do it, though you'll need to restart your postmaster for the
changes to take effect.

Robert Treat

On Tuesday 12 Nov 2002 7:30 pm, Williams, Travis L, NPONS wrote:

To change the max connections I'm assuming I need to edit the
postgresql.conf file and change this line: #max_connections = 32
to something like
max_connections = 64

I do need to uncomment this correct? Is there anything else I need to
change?

Travis - haven't seen anyone else reply, but basically "yes". While you're at
it you may want to look at some of the memory settings - more connections
means less RAM per connection.

You'll need to tell postgresql to reload the config file - "man pg_ctl" for
details.

--
Richard Huxton