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@sysd.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com