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

[MC Gonzalez <mgonzalez@xxxxxxxxxx>]

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>