On 3/21/17 08:12, Robert Haas wrote:
> I think a big part of the usability problem here comes from the fact
> that the default database for connections is based on the username,
> but the default databases that get created have fixed names (postgres,
> template1). So the default configuration is one where you can't
> connect. Why the heck do we do it that way?
Historical, probably. We could ponder changing the way the default
database is determined, but I don't want to imagine the breakage coming
out of that.
Some time ago I changed my environment to PGDATABASE=postgres by
default, and my experience has been much smoother. Of course, if we did
that, then people will store a bunch of junk in their postgres database.But maybe that's not a problem. Maybe just
toleratethe use of the
postgres database by default, like using the public schema.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services