Thread: Oh, Speaking of users and owning things....

Oh, Speaking of users and owning things....

From
Larry Rosenman
Date:
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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749