Skip site navigation (1) Skip section navigation (2)

Re: Starting PostgreSQL on OS X 10.8

From: Joel Hedden <jhedden(at)apple(dot)com>
To: Eric Lemings <eric(at)lemings(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Starting PostgreSQL on OS X 10.8
Date: 2012-08-17 19:21:59
Message-ID: 2415F3C8-EEF6-4522-8FEF-A226A9F2CD46@apple.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Eric,
After seeing that error, you should check the status with a "sudo serveradmin fullstatus postgres" to see if it is responsive.  That error may show up if the database startup takes longer than expected.  You could also try connecting with psql, etc.

Did you upgrade from an OS X Server Lion system?  If so, a log in /Library/Server/PostgreSQL/Migration should confirm whether pg_upgrade was run successfully.  Also /Library/Logs/ServerSetup.log should show 05_postgresmigrator.rb exiting with a result code 0.

Does /Library/Logs/PostgreSQL/PostgreSQL.log contain any hints, or anything at all?
Also check /var/log/system.log for "servermgr_postgres" entries.

Also be aware that other server services (Profile Manager, Wiki, Calendar & Contacts server) use this database instance and cluster, and toggling its state may affect those services.  We advise creating a new webapp plist (see 'man webappctl', 'man webapp.plist') with a dependency on 'org.postgres.postgresql' for your use.

Another option is to install PostgreSQL from a port (MacPorts, Homebrew, etc.) but the OS X Server installation should work for you.

It would also be interesting to know if the services that use postgres (mentioned earlier) are functional.  You could start the Wiki service, connect to http://127.0.0.1/ and create a new wiki page to confirm.

-Joel Hedden

On Aug 17, 2012, at 11:05 AM, Eric Lemings wrote:

> Greetings,
> 
> I have a Mac Mini Server which I recently upgraded to Mountain Lion and then again with the optional Server.app i.e. OS X Server.  Whenever I try starting PostgreSQL, I get the following:
> 
> $ sudo serveradmin start postgres
> postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"
> 
> I haven't been able to pinpoint the cause of this error.  Any help greatly appreciated.
> 
> Thanks,
> Eric.
> 
> 
> 
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

pgsql-admin by date

Next:From: Jonathan PoolDate: 2012-08-18 17:25:17
Subject: Installing PostgreSQL Yum Repository
Previous:From: Eric LemingsDate: 2012-08-17 18:05:42
Subject: Starting PostgreSQL on OS X 10.8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group