`~/.pgpass` not working

ppo

Hi,

I had configured a ~/.pgpass file a long time ago, and it was working. It doesn't anymore. Did something changed?

Error message: psql: FATAL: no pg_hba.conf entry for host "[local]", user "$USER", database "$USER", SSL off

The file permissions are correct: chmod 600 and chown $USER:$USER.
The content is like: hostname:port:database:username:password (actually *:*:*:user:password).
It's on opal6.

Thanks.

sean

ppo I can't seem to reproduce this on opal6 with a brand new database:

[opal6@opal6 ~]$ ls -l .pgpass
-rw-------. 1 opal6 opal6 26 Jan 20 14:18 .pgpass
[opal6@opal6 ~]$ cat .pgpass
*:*:*:oo6:xxxxxxxxx
[opal6@opal6 ~]$ psql -U oo6 oo6
psql (11.9)
Type "help" for help.

oo6=>

Can you please try re-assigning your DB user to the DB and let me know if that helps?

ppo

sean OK, I see where it comes from 🫤

psql -l doesn't work but psql -l X works (X = a database my user has access to).

I had initially that problem with my backup script that makes a query using the database postgres to SELECT datname FROM pg_database WHERE … (restricting to the DBs I've access to).
I managed to work around that problem by creating a dummy database for my user.

PS: BTW 😉 Is it really secure that anyone can list all the databases? => name and access privileges.

sean

ppo Is it really secure that anyone can list all the databases? => name and access privileges.

As far as I know this is an unfortunate fact of PostgreSQL. There are some hacky ways to work around it but we'd prefer not to.