On Fri, Jun 1, 2012 at 8:07 AM, Bryan Murphy
<bmurphy1976@gmail.com> wrote:
On Thu, May 31, 2012 at 4:28 PM, Jeff Davis
<pgsql@j-davis.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?
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