Re: [cobalt-users] RAQ3 PostgreSQL

[Jeff Bilicki <jeff@xxxxxxxxxxx>]

> Hi everyone,
> I deperately need help. I am on my last ditch effort. If I don't resolve
> this problem by Monday I will be forced to restore my RAQ3 to "original".
> I deleted PostgreSQL...and screwed up the UI (long story...short version - I
> screwed up).
> I managed to track down the
> ftp://ftp.cobaltnet.com/pub/products/raq3/RPMS/postgresql-6.5.2-C2.i386.rpm
> and the
> ftp://ftp.cobaltnet.com/pub/products/raq3/RPMS/postgresql-devel-6.5.2-C2.i38
> 6.rpm (thanks to Jeff) , PostgreSQL is installed but I am still missing the
> cobalt database.
> Here is what I am desperate for:

> 1) Directory structure/contents of postgresql on the raq3 should be
> /home/pgsql and I'm not sure if there are any other PostgreSQL files in
> other locations on the RAQ3 (something that i can compare to...to verify)

> 2) The RAQ3 cobalt database schema ( so i can manually rebuild the database)
> I believe the cobalt database is located at /home/pgsql please correct me if
> 'm wrong
> coast..no access to any other RAQ ..I am currently deployed in the south
> pacific so I have no physical access to the box and would have to pay
> someone there to serial link and "restore".
> Please feel free to contact me off-list.
> Previously, people suggested the use of meta-verify.pl, siteList.cgi ...
> these are all great solutions for a different problem, they only work if the
> cobalt database still exist.
> Sun recommends a "full restore".
> I like most of you refuse to believe that a "full restore" is the best
> solution. Maybe in this case it is, but I haven't given up yet....

The database tables should have been re-created with the installation of the
postgres rpms.  One way to check this is to  do the following:
$ less /etc/cobalt/.meta.id (you need to copy this password)
$ psql -u cobalt
Username: admin
Password: (the password in /etc/cobalt/.meta.id)

cobalt=> \dt
Database    = cobalt
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | admin            | bw                               | table    |
 | admin            | cpu                              | table    |
 | admin            | defcon                           | table    |
 | admin            | memory                           | table    |
 | admin            | network                          | table    |
 | admin            | quota                            | table    |
 | admin            | service                          | table    |
 | admin            | users                            | table    |
 | admin            | vsite                            | table    |
 +------------------+----------------------------------+----------+

cobalt=> select name,fqdn,ipaddr from vsite;
name   |fqdn          |      ipaddr
-------+--------------+------------
default|              |            
home   |q97.cobalt.com|172.16.99.97
(2 rows)

If the database is up and running, you should be able to use meta-verify.pl to
re-create all the database records. 

Jeff-