R7AF
asked on
[OSX] pg_ctl: could not open PID file
For some reason Posgresql won't start anymore. When I start PGAdmin I get the following message:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused
In the error log I find the following message:
com.apple.SystemStarter[21 ] pg_ctl: could not open PID file "/databases/postgresql/8.3 /postmaste r.pid": Permission denied
I've tried to reinstall Postgres, but nothing changed.
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused
In the error log I find the following message:
com.apple.SystemStarter[21
I've tried to reinstall Postgres, but nothing changed.
ASKER
I mean pgadmin3. I've been able to run Postgresql before. At some point you need to login. However, when I run Top, I don't see any postgresql processes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The postgres log reports the following:
com.apple.SystemStarter[21 ] pg_ctl: could not open PID file "/databases/postgresql/8.3 /postmaste r.pid": Permission denied
Should I look at other logs as well? Which ones in particular?
com.apple.SystemStarter[21
Should I look at other logs as well? Which ones in particular?
Check if postgresql user is owner of that file, make sure it is and start again.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good to know, thanks for keeping up with discussion.
ASKER
So guess what... That seemed to work, but after a restart... not anymore! Now I'm using the default installation, with the database files in /library/postgresql/8.3/da ta. Not what I want, but for now this problem is not important enough to give it more attention.
You need to run it as user that can connect to pid and socket of postgresql... Or use TCP with username and password.