Re: [cobalt-users] [RaQ4] Changing Main Host Name

["William J.A. Brillinger" <billy@xxxxxxxxxx>]

At 12:26 PM 01/02/03 -0500, you wrote:
> 1)   ssh to RaQ
> 2)   su  postgres
> 3)   cd /var/lib/pgsql/data/
> 4)   vi pb_hba.conf
> 5)   change crypt to trust
> 6)   pg_dump cobalt > cobalt.dump
> 7)   cp cobalt.dump  cobalt.dump.bak
> 8)   vi cobalt.dump
> 9)   change whtever, maybe the host name line, in the data section
> 10) dropdb cobalt
> 11) createdb cobalt
> 12) psql cobalt < cobalt.dump
> 13) vi pg_hba.conf
> 14) change trust to crypt
> 15) exit  (back to root)
> 16) run swatch
>
> If you have trouble with the edited database, do steps 2 - 5
> goto step 10 and in step 12. psql cobalt < cobalt.dump.bak
> finish as normal.

Made it to step 10 then:
[postgres data]# dropdb cobalt
psql: No pg_hba.conf entry for host localhost, user postgres, database 
template1
dropdb: database removal failed
[postgres data]#






---------------------------------
William J.A. Brillinger
Precision Design Co.

E-Mail:   mailto:billy@xxxxxxxxxx
Web site: http://www.pdcweb.net