Re: BUG #11090: Unclear error message in pg_upgrade

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.