| From: | rammohan ganapavarapu <rammohanganap(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | FQDN for replication connection in pg_hba.conf |
| Date: | 2017-10-10 22:08:00 |
| Message-ID: | CALm_Vjif_fy2XU-K3nUdQoDoxrzmtHHUZj+=5cpOkcmwc2J8zA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Can we use fqdn in pg_hba.conf for replication connections?
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 0.0.0.0/0 md5
host replication postgres *slave.example.com
<http://slave.example.com> * trust
I am getting below error in slave
2017-10-10 21:34:52 UTC [313]: [1-1] user= db= host= FATAL: could not
connect to the primary server: FATAL: no pg_hba.conf entry for replication
connection from host "10.10.10.10", user "postgres", SSL off where
"10.10.10.10" is my slave (*slave.example.com <http://slave.example.com>) *
ip.
Thanks,
Ram
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-10-10 22:17:15 | Re: FQDN for replication connection in pg_hba.conf |
| Previous Message | Scott Marlowe | 2017-10-10 16:05:38 | Re: Can master and slave on different PG versions? |