Re: [cobalt-users] PostgreSQL database for RaQ4 corrupted. Directions for rebuild?

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

----- Original Message ----- 
From: "Glenn Parsons" <gparsons@xxxxxxxxxxxxx>
To: "Cobalt-Users@xxxxxxxxxxxxxxx" <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Thursday, November 13, 2003 7:38 AM
Subject: [cobalt-users] PostgreSQL database for RaQ4 corrupted. Directions
for rebuild?


> Hello All,
>
> I''ve had this problem before and had help from the group to solve it.
Wish
> I had archived it!
>
> I need to fix the corrupted PostgreSQL db.
>
> The virtual hosts do not show up in the GUI. Instead, I get an error
> message. The rest of the GUI is accessible. Meta-verify will not fix the
> sites. Fix-site.pl will not fix the box. It is broken from attempting to
> restore a CMUexport, but I do not care about the virtual sites or users
> now. I want to revert to the original host, or any host that I can manage
> and take it from there. It would save me having to rebuild the OS and
patch
> for hours!
>
> Thanks,
> Glenn Parsons
>
>
Glenn

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
/etc/rc.d/init.d/postgresql stop
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 root
/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
ken@xxxxxxxxxxxxxxxx
http://www.precisionweb.net