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

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?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services