Re: 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