It was the shared buffers. Thanks to everyone for your quick and accurate responses.
Regards,
Edwin.
-----Original Message-----
From: Doug McNaught [mailto:doug@mcnaught.org]
Sent: Monday, 18 October 2004 11:45 AM
To: Edwin New
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to increase number of connections to 7.2.1
Edwin New <edwin_new@toll.com.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