Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.

[Tom Lane]

=?utf-8?q?PG_Doc_comments_form?=  writes:
> .pgpass does not work with 10.4

Works for me.  Care to provide a complete example?

$ cat $PGDATA/pg_hba.conf
...
# IPv4 local connections:
hostall all 127.0.0.1/32md5
# IPv6 local connections:
hostall all ::1/128 md5
...

regression=# create user joe password 'joespw';
CREATE ROLE

$ ls -l ~/.pgpass
-rw---. 1 tgl tgl 25 Jul 25 13:09 /home/tgl/.pgpass
$ cat ~/.pgpass
localhost:*:*:joe:joespw

$ psql -U joe -h localhost regression
psql (10.4)
Type "help" for help.

I can replicate your symptoms if there's not actually a matching
entry in the .pgpass file ...

regards, tom lane

Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.

[PG Doc comments form]

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:amd6410.4-0ubuntu0.18.04   
amd64PostgreSQL C client library
ii  postgresql-client   10+190
all  front-end programs for PostgreSQL (supported version)
ii  postgresql-client-1010.4-0ubuntu0.18.04   
amd64front-end programs for PostgreSQL 10
ii  postgresql-client-common190   
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.