Re: BUG #11090: Unclear error message in pg_upgrade - Mailing list pgsql-bugs

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Jeff Janes wrote:
>> I have one database with a retrospectively poor choice of initdb -U.  I
>> certainly wish there was a way, short of dump and restore, to change the
>> name of that user.  Although I don't think pg_upgrade would be the ideal
>> way to do that.

> Have you tried an UPDATE pg_authid?

Or even just ALTER USER RENAME?

            regards, tom lane