Thanks! Is there any way to figure out which the original superuser was?
:-)B On Jul 29, 2014, at 12:41, Tom Lane <t...@sss.pgh.pa.us> wrote: > Bror Jonsson <brorf...@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. > > regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
