Re: BUG #11090: Unclear error message in pg_upgrade

On 7/29/2014 11:58 AM, Alvaro Herrera wrote:
> brorfred@gmail.com  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.

so, if its enhanced with a -U newsuperuser flag, any objects owned by
'postgres' on the original cluster are now owned by 'newsuperuser' on
the new cluster?

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast