I ran into an "interestingness" with my 7.4 upgrade/testing.
It seems it's impossible (without editing the dump file), to reload a
pg_dumpall file
that has objects owned by one original user (postgres), into a new DB with
a new
original user (pgsql74).
Just food for someone to think about. (I changed the ownership to another
user in the
dump, and the problem is solved for me, but...).
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749