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 по дате отправления: