1 Feb 01:47
Re: postgres launch daemon not working
Scott Frankel <frankel <at> circlesfx.com>
2012-02-01 00:47:09 GMT
2012-02-01 00:47:09 GMT
Hi Ryan, On Jan 31, 2012, at 12:34 PM, Ryan Schmidt wrote: > > On Jan 31, 2012, at 13:52, Scott Frankel wrote: > >> Jan 31 08:26:02 tiento org.macports.postgresql84-server[1920]: server starting >> Jan 31 08:29:07 tiento com.apple.SystemStarter[53]: Starting PostgreSQL database server >> Jan 31 08:29:07 tiento com.apple.SystemStarter[53]: pg_ctl: could not open PID file "/Library/PostgreSQL8/data/postmaster.pid": Permission denied >> Jan 31 08:29:08 tiento SystemStarter[53]: PostgreSQL database server (90) did not complete successfully >> >> >> Looks like pg_ctl is trying to open a postmaster.pid file it doesn't have permissions for. How can I point launchd invocations of pg_ctl to the correct postgres data dir? I initialized my db according to info I gleaned from searches; eg: >> >> % sudo su postgres \ -c '/opt/local/lib/postgresql84/bin/initdb -D /opt/local/var/postgresql84/defaultdb' >> >> >> Prior to that, I reinstated the postgres user name with: >> >> % sudo dscl . -append /Users/postgres UniqueID 401 >> >> >> I assigned the postgres username to UID 401, as my previous installation's postgres files seemed to be owned by user 401 of group postgres. I wonder if this is the source of the permissions problem. >(Continue reading)
RSS Feed