Re: pg_upgrade patches applied

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > The last patch fixes a problem where I was not migrating
> > pg_largeobject_metadata and its index for 9.0+ migrations, which of
> > course would only affect migrations to 9.1 and 9.0 to 9.0 migrations, so
> > I backpatched that to 9.0.
> 
> That isn't going to work.  At least not unless you start trying to force
> roles to have the same OIDs in the new installation.

Uh, don't we store the pg_shadow.usesysid in pg_largeobject_metadata? 
If so I can use the CREATE ROLE ... SYSID clause when doing a binary
upgrade.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +