Edwin New <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])