On 7/29/2014 9:41 AM, Tom Lane wrote:
Bror Jonsson <brorfred@gmail.com> writes:
> I’m trying to upgrade from 9.0 to 9.2 with out any success. the pg_upgrade script fails with the message Old and new cluster install users have different values for pg_authid.oid:
> geo-route-in:~ bror$ /opt/local//lib/postgresql92/bin/pg_upgrade -b /opt/local//lib/postgresql90/bin/ -B /opt/local//lib/postgresql92/bin/ -d /Volumes/ruoteRAID/db/postgresql90/defaultdb/ -D /Volumes/ruoteRAID/db/postgresql92/defaultdb/ -u bror
At a guess, "bror" is not the original superuser in the old cluster
(ie, the one who ran initdb). You need to use the name of that
superuser, not just any superuser.
to clarify, the old cluster's install_user is postgres, while the new is bror. they must be the same. stop the new cluster, wipe the data dir out, and re-run initdb as the postgres user this time, THEN run the upgrade script with -u postgres
--
john r pierce 37N 122W
somewhere on the middle of the left coast