PostgreSQL without password prompt : .pgpass ignored

Question

I'm trying to enable root (Ubuntu 8.04) to use psql command without password prompt (for scripting purpose). Everything worked fine with PostgreSQL 8.3, but I migrate to PostgreSQL 8.4 and the login without password doesn't work anymore.

I've a correct .pgpass file (the same used for 8.3), the right of /root/.pgpass are 0600 but calling psql keep asking for a password.

NB : the PGPASSFILE variable is empty, so I assume that the .pgpass file is supposed to be used.

Any brilliant idea?

"strace -o <log_file> psql ... " and then look into the log file for ".pgpass". — Milen A. Radev
– Milen A. Radev, Commented Oct 1, 2010 at 10:02
Here are the lines containing .pgpass into the log file stat("/root/.pgpass", {st_mode=S_IFREG|0600, st_size=37, ...}) = 0 open("/root/.pgpass", O_RDONLY) = 3 stat("/root/.pgpass", {st_mode=S_IFREG|0600, st_size=37, ...}) = 0 open("/root/.pgpass", O_RDONLY) = 3 — AsTeR
– AsTeR, Commented Oct 1, 2010 at 11:32
I've also a line showing that pgsql found the password : read(3, "localhost:5432:dbname:usrname:passw"…, 4096) = 37 — AsTeR
– AsTeR, Commented Oct 1, 2010 at 11:35

Community · Accepted Answer · 2017-04-13 12:13:47Z

14

Try to check if this works:

*:*:*:postgres:password_for_postgres_user

And then try:

VERBOSITY=verbose psql --no-password --user postgres

This question should probably be migrated to serverfault.com.

edited Apr 13, 2017 at 12:13

CommunityBot

11 silver badge

answered Oct 1, 2010 at 11:59

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AsTeR Over a year ago

You are right it's more a server administration problem. The problem was that the server was installed right after postgres 8.3 and thus the installation make it run on the port 5433 instead of 5432. I fixed it by editing postgres.conf. Thanks !

Collectives™ on Stack Overflow

PostgreSQL without password prompt : .pgpass ignored

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related