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

[Matt Syracuse <syracuse@xxxxxxxxxxxxx>]

> 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


Ken,
thanks, that seemed to work. Now there is another problem:
my main site (the one tied to the ip address of the RaQ) is missing! AND, my
server will not serve any web pages - all 243 sites are down.

Another site [suspended] has assumed the role of the non-deletable site.

Any suggestions?

 /\/\att
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Matt Syracuse
Director of Information Technology