Re: [cobalt-users] Postgres Databse

[Gerald Waugh <gerald@xxxxxxxxx>]

On Thursday 03 January 2002 08:01 pm, Scott w wrote:
> 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.
>
Was it something lime this???
=================
Rebuild Postgre:  from webhostingtalk.com
 su to root :
 cd /home/pgsql
 su postgres
 vi pg_hba.conf
 change crypt to trust
 pg_dump cobalt > cobalt.dump
 vi cobalt.dump
 find create_table for quota. hash it out (comment it out# )
 destroydb cobalt
 createdb cobalt
 psql cobalt < cobalt.dump
 vi pg_hba.conf
 change trust back to crypt
 /usr/local/sbin/swatch
 ========================

Gerald