Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index - Mailing list pgsql-general

Bryan Murphy <bmurphy1976@gmail.com> writes:
> 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.

OID 10 is the bootstrap superuser, which is created with the name of the
operating system user that ran initdb.  So the above does not sound like
anything to do with custom vs stock builds, but with who did initdb.

It seems that pg_upgrade needs a check to make sure that the bootstrap
superuser is named the same in old and new clusters.

            regards, tom lane