Web Hosting Talk







View Full Version : postgresql fail. how-to remove n reinstall?


0218
09-23-2004, 03:08 PM
hi all,

anybody have install postgres into your machine?
I am facing fail to restart after server reboot.

I have try the method below from cpanel forum
f postgresql on Cpanel refuses to start even after reinstalling it from /scripts, try the following steps :

1. Delete the postgre files in /tmp.
2. rm -rf /var/lib/pgsql/data
3. su - postgres
4. initdb
5. start postgre from ssh
6. Go back and try the WHM functions again.

After doing #4 the msg. ends with:

Success. You can now start the database server using:

/usr/bin/postmaster -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

Chose the first option or start Postgres from WHM.



but the postgresql still fail.. May i know how to remove it and reinsatll it?