Category:Technology -> Adventures with the naked Mac Mini Server -> Repair PostgreSQL
Repair PostgreSQL service
It seems like every time I sneeze something goes wrong with Mac OS X 10.7.x Lion Server’s PostgreSQL databases and it always finishes by deleting its own log. PostgreSQL is used for the pre-installed Lion Server services. Here’s how to repair PostgreSQL in most instances:
- Open a terminal session and issue the following commands:
- Enter sudo serveradmin stop postgres.
- Enter sudo touch /Library/Logs/PostgreSQL.log.
- Enter sudo chown _postgres:_postgres /Library/Logs/PostgreSQL.log.
- Enter sudo serveradmin start postgres.
- Enter sudo serveradmin fullstatus postgres.
- Enter cd /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras.
- Enter sudo ./CoreCollaborationPostgreSQLExtras.sh.
- Enter sudo ./WebmailServerSetup.sh.
- Enter sudo ./create_caldavd_db.sh.
- Enter sudo ./create_devicemgr_db.sh.
- Enter sudo serveradmin start postgres.
- Enter sudo serveradmin fullstatus postgres.
