Thread: no pg_hba.conf entry for replication connection
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
On 02/09/2016 11:44 AM, Алексей Митропольский wrote: > 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 I don't recommend using "trust" for this. Use a .pgpass file instead to save the password. > > 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 Did you reload the master? -- -- Josh Berkus Red Hat OSAS (any opinions are my own)