Home → Managed Services → Server Administration → Postgresql 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