Alvaro Herrera <alvherre(at)2ndquadrant(dot)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