Re: [cobalt-users] Postgres Databse

["Bob Cruz" <bob@xxxxxxxxxxxxx>]

There are several tools that you could use to repair PostgreSQL. But it
really depends on what the problem is, does PostgreSQL still run? Can't find
the data? Is your virtusertable correct? Is it a RAQ3/4?

Here are some of the tools that have been succesful for us on a RAQ3, I
can't gaurantee the same for RAQ4 but should be similar.

(first make sure you backup your files as best you can)

1) To try rebuilding the virtual site list. telent/SSH in su -.

 #  /usr/admserv/cgi-bin/.cobalt/siteList/siteList.cgi

The following text is displayed on the screen :

(offline mode:enter name=value pairs on the standard input)

Press <Ctrl+d>

This should rebuild the list and you should be able to view the virtual
site list.

2) If this does not work, then I would suggest you to run the below
commands to check the database.

The meta-verify script will only repair the GUI interface if PostgrSQL is
functioning and your cobalt database is intact.

First locate the meta-verify.pl script using below commands or download into
your server if you cant find it:

# locate meta-verify.pl

# cd <location where meta-verify.pl exists>

# ./meta-verify.pl -si

Answer yes to all questions

#./meta-verify.pl -sa

Answer yes to all questions

#./meta-verify.pl -ui

Answer yes to all questions

#./meta-verify.pl -ua

Answer yes to all questions

# swatch

3) If that doesn't work you mayhave to rebuild the PostgrSQL database named
cobalt manually and then go back through step 1. Rebuilding the database
manually is not that difficult.

If you need the cobalt database schema for the RAQ3 or RAQ4 I will gladly
email it to you.



Regards,

Bob Cruz

----- Original Message -----
From: "Scott w" <webbcite@xxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Friday, January 04, 2002 11:01 AM
Subject: [cobalt-users] Postgres Databse


> There is a program or script that is used to fix corrupted postgres
> databases.  Anone know the name of it???  I have been searching the
archives
> (where I know it is...) and can't come up with it.
>
> It's not meta-verify...but something else.  I think it was suggested by a
> Cobalt Tech to the list in recent months.
>
> Thanks for the help...
>
>
> _________________________________________________________________
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>
>