The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html Description:
https://www.postgresql.org/docs/10/static/libpq-pgpass.html $ dpkg -l | grep -i postgres ii libpq5:amd64 10.4-0ubuntu0.18.04 amd64 PostgreSQL C client library ii postgresql-client 10+190 all front-end programs for PostgreSQL (supported version) ii postgresql-client-10 10.4-0ubuntu0.18.04 amd64 front-end programs for PostgreSQL 10 ii postgresql-client-common 190 all manager for multiple PostgreSQL client versions .pgpass does not work with 10.4 /home/ubuntu/.pgpass is 0600 (tried 0400 alsp), owner and group ubuntu with psql run as ubuntu. I tried adding an extra carriage return at the end of the file. Using psql with a -w, I get `psql: fe_sendauth: no password supplied`. Removing the -w, the error message is `psql: FATAL: password authentication failed for user "ubuntu"` after entering a password. I'm using the format from the doc page, `hostname:port:database:username:password`. There are no special characters in the user or pass (or anywhere). The docs are wrong, apparently this has been deprecated.