Search Postgresql Archives

no pg_hba.conf entry for replication connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux