From: | Kristjan Mustkivi <sonicmonkey(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | CREATE SUBSCRIPTION not picking up .pgpass while psql does |
Date: | 2022-08-31 13:03:31 |
Message-ID: | CAOQPKattt3g2dEKqiC9qdp4bxAHWipVO5fWy0En8MT9aw5SKmA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I do not understand why CREATE SUBSCRIPTION does not pick up .pgpass
(when psql does):
root(at)pg(dot)newtest:/# psql 'host=pg.oldtest port=5432 user=pg_replication
dbname=oldtest'
oldtest=# \q
root(at)pg(dot)newtest:/# psql newtest postgres
newtest=# CREATE SUBSCRIPTION sub_pgupgrade CONNECTION
'host=pg.oldtest port=5432 user=pg_replication dbname=oldtest'
PUBLICATION pub_pgupgrade;
ERROR: could not connect to the publisher: connection to server at
"pg.oldtest" (x.x.x.x), port 5432 failed: fe_sendauth: no password
supplied
newtest=#
oldtest is 11.15 (Debian 11.15-1.pgdg90+1)
newtest is 14.5 (Debian 14.5-1.pgdg110+1)
.pgpass is under /root (home inside the docker container) with 0600
permissions and owned by user "postgres". Even providing
passfile=/root/.pgpass in the connstring does not work.
.pgpass contains:
*:*:*:pg_replication:password
Any thoughts on how to debug much appreciated.
Best regards,
--
Kristjan Mustkivi
Email: kristjan(dot)mustkivi(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2022-08-31 13:07:20 | Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does |
Previous Message | Tom Lane | 2022-08-30 17:07:51 | Re: Missing query plan for auto_explain. |