Bruce Momjian <pgman@candle.pha.pa.us> writes:
> How about if we just document that they have to create a
> postgres@template1 user before flipping the switch. That way, there is
> no special user, no PG_INSTALLER file, and no double-tests for user
> names.
... and no useful superuser account; if you can't connect to anything
except template1 then you ain't much of a superuser.
To get around that you'd have to create postgres@db1, postgres@db2,
postgres@db3, etc etc. This would be a huge pain in the neck; I think
it'd render the scheme impractical. (Keep in mind that anybody who'd be
interested in this feature at all has probably got quite a number of
databases to contend with.)
regards, tom lane