no pg_hba.conf entry for replication connection

From: Алексей Митропольский <mitr2503(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: no pg_hba.conf entry for replication connection
Date: 2016-02-09 10:44:41
Message-ID: 1455014681.926784275@f84.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I have tried to set up streaming replication (Postgres 9.4.5.3 Linux).
pg_hba.conf on the master server have entry:
host replication postgres 192.168.50.36 trust
When I start the standby server (192.168.50.36) I get errors in the logs:
LOG: entering standby mode
LOG: restored log file "0000...10" from archive
LOG: redo starts at 0/10000788
LOG: consistent recovery state reached at 0/11000000
LOG: database system is ready to accept read only connections
LOG: scp: /opt/PostgreSQL/9.4/data/arch_dest/0000..11: No such file or directory
LOG: invalid magic number 0000 in ljg segment 0000..11, offset 0
FATAL: could not connect to the primary server: FATAL: no pg_hba.conf
entry for replication connection from host "192.168.50.36",
user "postgres", SSL off

Sincerely yours,
Alexey Mitropolsky

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh berkus 2016-02-09 11:17:58 Re: no pg_hba.conf entry for replication connection
Previous Message Harald Fuchs 2016-02-09 09:35:43 Re: execute same query only one time?