Re: [cobalt-users] Rebuild PostgreSQL 'cobalt' database

[Bo von Hohenlohe <bvhprods@xxxxxxx>]

>> >>If the Rebuild Postgre fails is the following the right script to
>> >> restore data base from cobalt.dump.bak?
>
>Yes, but I have never seen it fail personally...
>
>> >On the  Rebuild Postgre instructions at
>> >http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html
>> >there is  the following script to check the ntegrity of the data base,
>> > is it necessary to check it before and after rebuilding postgre?
>
>You would do the check after running the swatch step which actually
>rebuilds the quota table.
>
>> One last question...  Before I Rebuild Postgre do I need to disable any
>> services on my server?
>
>Active Monitor might freak out, but none of the services like web, mail,
>etc depend on the PostgreSQL database for their operation.  It's solely to
>power the UI.



Sorry, the questions keep coming...

1) How does ones shut down and restart the Active Monitor process?

2) How does one check if the data base was successfully created?
su - postgres
psql cobalt
SELECT * FROM quota;

Is this correct?

Thanks.

Bo von Hohenlohe
Bo von Hohenlohe Productions
bvhprods@xxxxxxx
http://www.artfreak.com
http://www.maddogcom.com/