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

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Sunday 02 February 2003 09:51, William J.A. Brillinger wrote:
> 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)   enter a line under local cobalt crypt
               local all trust
            and comment out local cobalt crypt
> >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) comment out local all trust
            local cobalt crypt
            #local all trust
> >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]#
>

I put the following in pg_hba.conf 
local cobalt crypt
#local all trust
Then I uncomment local all trust and comment out local cobalt crypt
I expect there is a better way to do it but this works.

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