Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] FQDN for replication connection in pg_hba.conf - Mailing list pgsql-admin

From David G. Johnston
Subject Re: [ADMIN] FQDN for replication connection in pg_hba.conf
Date
Msg-id CAKFQuwaG0hDigdJ0F6JNj+GcD6LePcLWoxSfq00JFAbzd4cwcg@mail.gmail.com
Whole thread Raw
In response to [ADMIN] FQDN for replication connection in pg_hba.conf  (rammohan ganapavarapu <rammohanganap@gmail.com>)
Responses Re: [ADMIN] FQDN for replication connection in pg_hba.conf
List pgsql-admin
Tree view
On Tue, Oct 10, 2017 at 3:08 PM, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:
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          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)  ip.


​The comments and note under "address" at the following link suggest that what you are trying is possible.  Hopefully they can shed some light as to what to check in order to find out why it is not working in your case.​  In particular, are both DNS entries configured?


​Ensure you reload the configuration after making changes.
​
​I don't recall whether having a all/all/any entry above your replication entry is going to be problematic - but that wouldn't explain a "no pg_hba.conf entry" error.

David J.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] FQDN for replication connection in pg_hba.conf
Next
From: Scott Mead
Date:
Subject: Re: [ADMIN] Can master and slave on different PG versions?