Robert Haas wrote:
> On Wed, Jan 5, 2011 at 9:44 PM, Bruce Momjian <bruce@momjian.us> wrote:
> > I think pg_dumpall would have failed with this setup too, so I don't see
> > this as a pg_upgrade bug, nor something that I am willing to risk adding
> > to pg_upgrade.
>
> If adding RESET SESSION AUTHORIZATION fixes the bug, I think we should
> consider doing that.
If we add every fix that could conceivably break a pg_dumpall restore,
pg_upgrade will be less stable than it is now. I don't see why adding
this should be any different.
If you want to argue that pg_dumpall should be doing it, that is a
separate issue and not related to pg_upgrade.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +