Re: Moving a database AND changing the superuser

In my opinion, the only thing you need to change is the name of the
superuser in your dump file.

Bruno

Rich Cullingford wrote:

> 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.)
> Thanks,
> Rich Cullingford
> System Detection, Inc.
> rculling(at)sysd(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com