From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems with pg_upgrade. |
Date: | 2014-07-29 16:45:49 |
Message-ID: | 53D7CFBD.7060506@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/29/2014 9:41 AM, Tom Lane 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-07-29 16:52:58 | Re: Problems with pg_upgrade. |
Previous Message | Bror Jonsson | 2014-07-29 16:43:55 | Re: Problems with pg_upgrade. |