Skip site navigation (1) Skip section navigation (2)

Re: Moving a database AND changing the superuser

From: Marek Florianczyk <franki(at)tpi(dot)pl>
To: Rich Cullingford <rculling(at)sysd(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving a database AND changing the superuser
Date: 2003-12-15 15:56:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
W liƛcie z pon, 15-12-2003, godz. 16:30, Rich Cullingford pisze: 
> All,
> I did a pg_dumpall in preparation for moving one of our databases from 
> PG7.3 to PG7.4, but I just realized I have another problem: that DB 
> (which has served us faithfully for some time) was created for superuser 
> 'postgres,' whilst our new DBs use a superuser name that's aligned with 
> our product. I'm expecting conflicts when I try to restore the data into 
> a 'new' DB. Am I right, and if so, what can I do? (I know I could just 
> try it, but the old database machine will be disappearing soon, and if I 
> need to do a different kind of dump -- per DB, for example -- I need to 
> know that soonest.)

Well can't you just change all appearance of 'postgres' word to some
other eg.
cat dump.sql|sed -e 's/postgres/new_admin/g' > new_dump.sql

of course you must check first if word 'postgres' is used in any other
context, and maybe do some correction by hand.


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2003-12-15 16:10:01
Subject: Re: Shutdown pg db
Previous:From: Bruno LEVEQUEDate: 2003-12-15 15:54:56
Subject: Re: Moving a database AND changing the superuser

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group