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

Reply via email to