Postgres Pro
Downloads
Home   >   mailing lists

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

From rammohan ganapavarapu
Subject [ADMIN] FQDN for replication connection in pg_hba.conf
Date
Msg-id CALm_Vjif_fy2XU-K3nUdQoDoxrzmtHHUZj+=5cpOkcmwc2J8zA@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] FQDN for replication connection in pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [ADMIN] FQDN for replication connection in pg_hba.conf  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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.

Thanks,
Ram

pgsql-admin by date:

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