by kraada » Thu Jun 30, 2011 12:51 pm
Open terminal (in Applications -> Utilities) and run this command:
sudo chmod -R 700 /Library/PostgreSQL/8.4/data/
It'll prompt for a password, use your Mac user password then hit enter - you won't see *s as a security precaution.
Once it finishes running, try starting the service and it should work properly then.