Re: [cobalt-users] can't admin/view my virtual sites via the gui

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

> One of my RaQ4's is reporting:
> The PostgreSQL server is down and cannot be restarted.
> 
> When I run meta-verify -si and respond Y or y, I get this error:
> Can't call method "exec" on an undefined value at
> /usr/lib/perl5/site_perl/5.005/Cobalt/Meta.pm line 1479, <STDIN> chunk 1.
> 
> Help! How can I rebuild the PostgreSQL db without losing any data?
> 
> Thanks!
> 
>  /\/\att
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Matt Syracuse
> Director of Information Technology
> 


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 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