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