pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Starting PostgreSQL on OS X 10.8
2+ messages / 2 participants
[nested] [flat]

* Starting PostgreSQL on OS X 10.8
@ 2012-08-17 18:05 Eric Lemings <eric@lemings.com>
  2012-08-17 19:21 ` Re: Starting PostgreSQL on OS X 10.8 Joel Hedden <jhedden@apple.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Eric Lemings @ 2012-08-17 18:05 UTC (permalink / raw)
  To: pgsql-admin

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Starting PostgreSQL on OS X 10.8
  2012-08-17 18:05 Starting PostgreSQL on OS X 10.8 Eric Lemings <eric@lemings.com>
@ 2012-08-17 19:21 ` Joel Hedden <jhedden@apple.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joel Hedden @ 2012-08-17 19:21 UTC (permalink / raw)
  To: Eric Lemings <eric@lemings.com>; +Cc: 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2012-08-17 19:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-17 18:05 Starting PostgreSQL on OS X 10.8 Eric Lemings <eric@lemings.com>
2012-08-17 19:21 ` Joel Hedden <jhedden@apple.com>

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