From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #11090: Unclear error message in pg_upgrade |
Date: | 2014-07-29 20:40:45 |
Message-ID: | 1406666444963-5813220.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Alvaro Herrera-9 wrote
> brorfred@
> wrote:
>
>> pg_upgrade requires that the old and new database has the same install
>> superuser (superuser that ran initdb). If this requirement isn't
>> fulfilled,
>> you'll get the following error:
>>
>> "Old and new cluster install users have different values for
>> pg_authid.oid.\n"
>
> To me, the bug is that we required both superusers to be named the same
> in the first place.
It seems a reasonable limitation for something the simply purports to
"upgrade". The data should not be changed in the process.
My question: is there a way to change the name of the assigned install user
as long as you can manage to ensure they have the same oid? The error
implies there is.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-11090-Unclear-error-message-in-pg-upgrade-tp5813198p5813220.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-07-29 20:44:18 | Re: BUG #11090: Unclear error message in pg_upgrade |
Previous Message | John R Pierce | 2014-07-29 19:53:00 | Re: BUG #11090: Unclear error message in pg_upgrade |