psql's default database on connect (our internal ref. SRP-30861)

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: psql's default database on connect (our internal ref. SRP-30861)
Date: 2021-08-06 06:53:22
Message-ID: YQzcYh1tAdp72LIZ@c720-r368166
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

testpos(at)srap53dxr1:~> psql --help
...
-d, --dbname=DBNAME database name to connect to (default: "testpos")

testpos(at)srap53dxr1:~> whoami
testpos

testpos(at)srap53dxr1:~> env | grep PG
PGPASSWORD=xxxxxxxx
PGHOST=localhost
PGPORT=5432

testpos(at)srap53dxr1:~> LANG=C psql -Usisis
psql (13.3)
Type "help" for help.

sisis=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
sisis | sisis | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
...

Why psql connects to the database 'sisis'? I was expecting that it
will try to connect to a database 'testpos' as this is the UNIX login
and as '-d....' was not specified. I was expecting in this case an
error like this:

testpos(at)srap53dxr1:~> export PGDATABASE=testpos
testpos(at)srap53dxr1:~> psql -Usisis
psql: error: FATAL: database »testpos« does not exist

What do I uderstand wrong?

matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2021-08-06 07:07:56 Re: psql's default database on connect (our internal ref. SRP-30861)
Previous Message David G. Johnston 2021-08-06 06:02:44 Re: Series of 10 questions about the use of postgresql, generally.