Re: [HACKERS] pg_upgrade patches applied

2011-01-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> 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. > > > If so I can use the CREATE ROLE ... SYSID clause when doing a binary > > upgrade. > > Oh, I ha

Re: [HACKERS] pg_upgrade patches applied

2011-01-05 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> 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. > If so I can use the CREATE ROLE ... SYSID clause when doing a binary > upgrade. Oh, I had forgotten we still had that wart

Re: [HACKERS] pg_upgrade patches applied

2011-01-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian 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 g

Re: [HACKERS] pg_upgrade patches applied

2011-01-05 Thread Tom Lane
Bruce Momjian 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 un