How to fix or stop postgres errors?

Question

Level 10

250,259 points

How to fix or stop postgres errors?

10/5/11 7:41:12.633 PM org.postgresql.postgres: 2011-10-05 19:41:12 PDT FATAL: could not create log file "/Library/Logs/PostgreSQL.log": Permission denied

10/5/11 7:41:12.634 PM com.apple.launchd: (org.postgresql.postgres[1234]) Exited with code: 1

10/5/11 7:41:12.634 PM com.apple.launchd: (org.postgresql.postgres) Throttling respawn: Will start in 10 seconds

Lion Server.10.7.2

Other OS

Posted on Oct 5, 2011 8:02 PM

Reply

Answer 1

BDAqua Author

Level 10

250,259 points

Oct 5, 2011 8:06 PM in response to BDAqua

Looks like Permission are correct on the whole path, & nothing else has problems writing logs there.!?

Do I maybe need to add _postgres as a user there?

Reply

Answer 2

BDAqua Author

Level 10

250,259 points

Oct 7, 2011 7:50 PM in response to BDAqua

Well, so far I got the logging shut off by editing the plist, will later try changing the log path to see what it's trying to log.

Reply

Answer 3

BDAqua Author

Level 10

250,259 points

Dec 3, 2011 12:39 AM in response to BDAqua

fraqmless provided the solution here...

https://discussions.apple.com/thread/3336521?answerId=16502365022#16502365022

Reply