Re: [cobalt-users] Posgresql has corrupted need to rebuild

[Ken Marcus -Precision Web Hosting <ken@xxxxxxxxxxxxxxxx>]

> >The PostgreSQL server is down and cannot be restarted
>
> >I have restarted postgres but it seems postgresql
> >connection problem..


For a raq4, if you follow the steps below it will fix it easily in 10
minutes, they are from:
http://list.cobalt.com/pipermail/cobalt-users/2002-January/062036.html

su root
mkdir /var/lib/pgsql/dataold
mv /var/lib/pgsql/data  /var/lib/pgsql/dataold
mkdir /var/lib/pgsql/data
chown postgres:postgres /var/lib/pgsql/data
chmod 700 /var/lib/pgsql/data
su postgres
initdb -D /var/lib/pgsql/data
su
/etc/rc.d/init.d/postgresql stop
/etc/rc.d/init.d/postgresql start
cd /usr/local/sbin
./meta-verify -si
Answer yes to all questions   uppercase Y
./meta-verify -sa
Answer yes to all questions
./meta-verify -ui
Answer yes to all questions
#./meta-verify -ua
Answer yes to all questions
/usr/local/sbin/swatch
<<


----
Ken Marcus
Precision Web Hosting
mailto:ken@xxxxxxxxxxxxxxxx
http://www.precisionweb.net