Re: Problems with pg_upgrade.

Thanks!

Is there any way to figure out which the original superuser was?

:-)B

On Jul 29, 2014, at 12:41, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Bror Jonsson <brorfred(at)gmail(dot)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.
>
> regards, tom lane