On Tue, Mar 21, 2017 at 10:43 AM, David Steele <david@pgmasters.net> wrote:
> I suppose it would be too big a change to have psql try the username and
> then fallback to postgres on failure?
It's not so much that the change would be too big as that the
resulting semantics would be confusing, at least IMHO. Imagine:
1. Person A logs into the service account, runs psql, starts creating
stuff in postgres DB without realizing it.
2. Person B logs into the service account, runs psql -l, sees that the
usual DB name is not there, runs createdb.
3. Person A reruns psql and says "where'd all my stuff go?".
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company