From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: postgress@sendthemtomir.com
Subject: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.
Date: Tue, 24 Jul 2018 21:32:09 +0000
Message-ID: <153246792915.1402.4290097572382403810@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, postgress@sendthemtomir.com
Subject: Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.
In-Reply-To: <153246792915.1402.4290097572382403810@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox