From: Joel Hedden <jhedden@apple.com>
To: Eric Lemings <eric@lemings.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Starting PostgreSQL on OS X 10.8
Date: Fri, 17 Aug 2012 12:21:59 -0700
Message-ID: <2415F3C8-EEF6-4522-8FEF-A226A9F2CD46@apple.com> (raw)
In-Reply-To: <45DCD5BC-D4B7-4E9C-BEF0-11B62AEC6813@lemings.com>
References: <45DCD5BC-D4B7-4E9C-BEF0-11B62AEC6813@lemings.com>
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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jhedden@apple.com, eric@lemings.com
Subject: Re: Starting PostgreSQL on OS X 10.8
In-Reply-To: <2415F3C8-EEF6-4522-8FEF-A226A9F2CD46@apple.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox