Fw: [cobalt-users] The PostgreSQL server is down and cannot be restarted error...

["Gerald Waugh" <gerald@xxxxxxxxx>]

> Txs, but below solution does NOT work here!
> The pg_hba.conf file ONLY has this line set:
> local cobalt trust
>
> pg_dump cobalt > cobalt.dump results into an empty cobalt.dump file.......
> without error message.
>
> What GOES wrong?
>
> and createdb testdatabase
> gives the error message:
> psql: No pg_hba.conf entry for host localhost, user postgres, database
> template1
> createdb: database testdatabase creation failed
>
> Also after adding the line
> host all 127.0.0.1 255.255.255.255 trust
> to the pg_hba.conf file.
>
> What goes wrong OR is it no problem to destroydb cobalt and the createdb
> cobalt ???
>
> Please advise.
>
> CK
>
>
>
> At 09:09 16-10-2001 -0700, you wrote:
> >I haven't used this, but it is supposed to fix a corrupted postgre GUI
> >database
> >
> >
> >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
> >
> >
> >
> ------------SINDS 1996 Uw betrouwbare Internet Partner------------
>  U-Online                ==   The Server / WebCreator Specialists
>  Rijksweg 35-B           ==   !! Best care for your domain !!
>  6584 AA  Molenhoek LB   ==   !! Webcreatie / WebShops / Database
>  Tel.: +31-24-388 0288   ==   Zie: http://www.u-online.com
>  Fax.: +31-484 310 455   ==   Mailto: info@xxxxxxxxxxxx
> ------------------------------------------------------------------
>
>