Bryan Murphy <bmurphy1976@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
