MIME-version: 1.0
Content-type: multipart/alternative;
	boundary="Boundary_(ID_vCvQVyQjru7oq+wp+L5JXg)"
Subject: Re: Starting PostgreSQL on OS X 10.8
From: Joel Hedden <jhedden@apple.com>
In-reply-to: <45DCD5BC-D4B7-4E9C-BEF0-11B62AEC6813@lemings.com>
Date: Fri, 17 Aug 2012 12:21:59 -0700
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Message-id: <2415F3C8-EEF6-4522-8FEF-A226A9F2CD46@apple.com>
References: <45DCD5BC-D4B7-4E9C-BEF0-11B62AEC6813@lemings.com>
To: Eric Lemings <eric@lemings.com>


--Boundary_(ID_vCvQVyQjru7oq+wp+L5JXg)
Content-type: text/plain; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT

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


--Boundary_(ID_vCvQVyQjru7oq+wp+L5JXg)
Content-type: text/html; CHARSET=US-ASCII
Content-transfer-encoding: quoted-printable

<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi =
Eric,<br>After seeing that error, you should check the status with a =
"sudo serveradmin fullstatus postgres" to see if it is responsive. =
&nbsp;That error may show up if the database startup takes longer than =
expected. &nbsp;You could also try connecting with psql, etc.<br><br>Did =
you upgrade from an OS X Server Lion system? &nbsp;If so, a log in =
/Library/Server/PostgreSQL/Migration should confirm whether pg_upgrade =
was run successfully. &nbsp;Also /Library/Logs/ServerSetup.log should =
show 05_postgresmigrator.rb exiting with a result code 0.<br><br>Does =
/Library/Logs/PostgreSQL/PostgreSQL.log contain any hints, or anything =
at all?<br>Also check /var/log/system.log for "servermgr_postgres" =
entries.<br><br>Also be aware that other server services (Profile =
Manager, Wiki, Calendar &amp; Contacts server) use this database =
instance and cluster, and toggling its state may affect those services. =
&nbsp;We advise creating a new webapp plist (see 'man webappctl', 'man =
webapp.plist') with a dependency on 'org.postgres.postgresql' for your =
use.<br><br>Another option is to install PostgreSQL from a port =
(MacPorts, Homebrew, etc.) but the OS X Server installation should work =
for you.<br><br>It would also be interesting to know if the services =
that use postgres (mentioned earlier) are functional. &nbsp;You could =
start the Wiki service, connect to&nbsp;<a =
href=3D"http://127.0.0.1/">http://127.0.0.1/</a>&nbsp;and create a new =
wiki page to confirm.<br><br>-Joel Hedden<div><br><div><div>On Aug 17, =
2012, at 11:05 AM, Eric Lemings wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote =
type=3D"cite"><div>Greetings,<br><br>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. &nbsp;Whenever I try starting PostgreSQL, I =
get the following:<br><br>$ sudo serveradmin start =
postgres<br>postgres:error =3D =
"CANNOT_START_SERVICE_TIMEOUT_ERR"<br><br>I haven't been able to =
pinpoint the cause of this error. &nbsp;Any help greatly =
appreciated.<br><br>Thanks,<br>Eric.<br><br><br><br>-- <br>Sent via =
pgsql-admin mailing list (<a =
href=3D"mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)=
<br>To make changes to your subscription:<br><a =
href=3D"http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgre=
sql.org/mailpref/pgsql-admin</a><br></div></blockquote></div><br></div></b=
ody></html>=

--Boundary_(ID_vCvQVyQjru7oq+wp+L5JXg)--