| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bror Jonsson <brorfred(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problems with pg_upgrade. |
| Date: | 2014-07-29 16:41:05 |
| Message-ID: | 2578.1406652065@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bror Jonsson <brorfred(at)gmail(dot)com> writes:
> Im 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bror Jonsson | 2014-07-29 16:43:55 | Re: Problems with pg_upgrade. |
| Previous Message | Tom Lane | 2014-07-29 16:38:16 | Re: Re: [GENERAL] pg_dump behaves differently for different archive formats |