HomeManaged ServicesServer AdministrationPostgresql system database will not start or restart

1.6. Postgresql system database will not start or restart

SYMPTOMS:
The postgresql system database on the control panel server will not start or restart.

 

RESOLUTION:
Take the following steps in order from least invasive to most invasive:

1.  Make sure there is no postgresql pid file (extension will be .pid) in /var/run and ~postgres/data

If you find .pid files, remove them; and then try restarting postgresql.

If that fails, then

2.  Edit /etc/sysctl.conf and make sure the following two lines are present (add them if they are not present):

kernel.shmall = 556742272
kernel.shmmax = 556742272

Save the file, and then run the following command:

sysctl -p

Try restarting postgresql.

If that fails, then

3.  Restore ~postgres/data/postgresql.conf from backup; chances are high some one changed the "sort_mem and shared_buffers" values in the file.

http://www.psoft.net/HSdocumentation/sysadmin/cp_acceleration.html#pgsql_memory_usage talks about these values; but they should be changed with caution.

ALSO, see http://www.psoft.net/HSdocumentation/sysadmin/fixing_hs_database.html

This page was: Helpful | Not Helpful