Friday, July 9, 2010

Error starting Postgres

The postgres database service on my fedora box has failed to start
I say
service postgresql restart

it says

#Starting postgresql service: /etc/init.d/postgresql: line 114: echo: write error: Permission denied


I am trying with root access and it was working fine before the reboot. I have not installed anything new. :-(

Solution:

Thanks to Aasif Shaikh for his timely help
This was the mantra he used

# su - postgres -c "/usr/local/pgsql/bin/pg_ctl start -l logfile -D /usr/local/pgsql/data"


OR use this if the above says file not found

# su - postgres -c "/usr/bin/pg_ctl start -l logfile -D /usr/local/pgsql/data"


And postgres was up and running :-)

-UVT

PS- Postgres sucks!

2 comments: