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!
Nice tip, thanks!
ReplyDelete/tmp/.s.PGSQL.5432.lock": Permission denied
ReplyDelete