Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index

On Fri, Jun 1, 2012 at 8:07 AM, Bryan Murphy <bmurphy1976(at)gmail(dot)com> wrote:

> On Thu, May 31, 2012 at 4:28 PM, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
>
>> On Thu, 2012-05-31 at 15:55 -0500, Bryan Murphy wrote:
>> > I'm having a problem upgrading a cluster from 9.0.7 to 9.1.3. Here's
>> > the error:
>>
>> Please send /srv/pg_upgrade_dump_globals.sql
>>
>> Also, can you restart the old system (by removing the ".old" suffix, as
>> the message suggests), and then do a "SELECT oid,* FROM pg_authid" and
>> send the output along?
>>
>
> Here's the requested data: https://gist.github.com/2852014
>
> I had to censor some of it because it contained sensitive information,
> hopefully the censoring is obvious and I don't believe I touched any of the
> functional information.
>

OK, I seem to have figured it out. Your questions pointed me in the right
direction.

The old 9.0 cluster was created by ubuntu. In this cluster there was an
ubuntu user with an oid of 10 and a postgres user with an oid of 16386.

The new 9.1 cluster was created with a custom build of postgres 9.1. This
did not have an ubuntu user, and it had a postgres user with an oid of 10.

I renamed the postgres user in the old 9.0 cluster to pg, renamed the
ubuntu user to postgres, and then re-ran pg_upgrade and it appears to have
worked correctly this time.

Bryan