Re: BUG #11090: Unclear error message in pg_upgrade

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: BUG #11090: Unclear error message in pg_upgrade
Дата
Msg-id 1406666444963-5813220.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: BUG #11090: Unclear error message in pg_upgrade  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: BUG #11090: Unclear error message in pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: BUG #11090: Unclear error message in pg_upgrade
Следующее
От: David G Johnston
Дата:
Сообщение: Re: BUG #11090: Unclear error message in pg_upgrade