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