What error do you get when the server fails to restart? It sounds like
it could be a kernel resource issue. See:
http://www.postgresql.org/docs/7.4/static/kernel-resources.html
-tfo
On Oct 17, 2004, at 8:15 PM, Edwin New wrote:
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.
I know we should upgrade from 7.2.1 and that is going to happen soon,
but this is a production server and I need a solution sooner.
Thanks in advance,
Edwin New
Analyst Programmer
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings