RE: [cobalt-users] RAQ4-postgres/gui errors and rebuild

["DeSign Co. - The web Pro's" <design-co@xxxxxxxxxx>]

This must be common? It happened to me on Friday as well!  Anyone know why
this happens? The server was running slow so I did a reboot and I can only
assume the DB was being written to when the server restarted. Anyone know of
a way to prevent this as well?

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of MC Gonzalez
Sent: Wednesday, June 18, 2003 3:36 PM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] RAQ4-postgres/gui errors and rebuild


On Wed, 2003-06-18 at 12:34, Ken Marcus - Precision Web Hosting wrote:

> It seems liek if you just delete the entire database and rebuild it,
> that should fix the problem.
> I've done that before usign the instructions at the url below and it
> works.
> http://list.cobalt.com/pipermail/cobalt-users/2002-January/062036.html
> >>
> - Logged in as root
> - Backed up all data in /var/lib/pgsql/data (just in case)
> - Deleted all content under /var/lib/pgsql/data
> - Switched to postgres user (# su postgres)
> - Executed the PostgreSQL initdb command to initiate a fresh data
> structure
> in the same location: # initdb -D /var/lib/pgsql/data
> - Switched back to root
> - Started PostgreSQL server:
>     /etc/rc.d/init.d/postgresql stop
> # /etc/rc.d/init.d/postgresql start
> - Used the cobalt meta-verify script to reinstate the data in the
> database:
> # 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

Hi Ken,

If for whatever reason things don't work right, will replacing all the
files that I backed up from the /var/lib/pgsql/data directory take me
back to where I started?

Being the pessimist I am, I always like to know I have a plan to get
back to where I was :)

Thanks!


--
MC Gonzalez <mgonzalez@xxxxxxxxxx>

_____________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users