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 tolerate the 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
