Re: How to increase number of connections to 7.2.1

It was the shared buffers. Thanks to everyone for your quick and accurate
responses.

Regards,

Edwin.

-----Original Message-----
From: Doug McNaught [mailto:doug(at)mcnaught(dot)org]
Sent: Monday, 18 October 2004 11:45 AM
To: Edwin New
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] How to increase number of connections to 7.2.1

Edwin New <edwin_new(at)toll(dot)com(dot)au> writes:

> I need to increase the number of connections to PostgreSQL 7.2.1.
>
>
> I have tried changing the value of max_connections in
> Postgresql.conf. It was commented out (as are all other entries
> except "tcpip_socket = true"). Setting it to any other value that the
> default 32 resulted in the server failing to restart.

1) Make sure your shared_buffers setting is big enough to handle your
desired connection limit.

2) Make sure your kernel's shared memory limits allow for your
shared_buffers setting.

If you can't get it to start, please post the server log entries from
the failed attempt--otherwise we have nothing to go on.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863