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

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Docs for version 10 incorrectly claim that ~/.pgpass with 0600 permswork.
Дата
Msg-id 153246792915.1402.4290097572382403810@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.
Список pgsql-docs
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.

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Parameter types are inferred from context of first use only.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work.