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

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Saturday 01 February 2003 11:41, William J.A. Brillinger wrote:
> At 11:04 AM 01/02/03 -0500, you wrote:
> >You might try dumping the postgre cobalt database,
> >Save a copy.
> >Edit the dump to correct the information.
> >destroy the cobalt database.
> >Import the edited cobalt database.
> >and see if that works....
> >If you get into trouble, destroy cobalt again, and import the saved
> > database.
> >
>
> Like I know how to do that :)

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.

Gerald
-- 
http://frontstreetnetworks.com | http://store.raqware.com
Front Street Networks LLC      |  Phone: 203-785-0699
229 Front Street, Ste #C, New Haven, CT 06513-3203