| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | postgress(at)sendthemtomir(dot)com |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work. |
| Date: | 2018-07-25 17:12:55 |
| Message-ID: | 6668.1532538775@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
=?utf-8?q?PG_Doc_comments_form?= <noreply(at)postgresql(dot)org> 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:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2018-07-26 09:24:37 | public schema |
| Previous Message | PG Doc comments form | 2018-07-24 21:32:09 | Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work. |