I added the standby server to the pg_hba.conf on the master server and confirmed that it worked by logging into the master server from the command line on the client.

hostnossl postgres all xxx.xxx.xxx.xxx trust

Without this entry I cannot log into the master from the command line on the client. With it I can. Went through the other steps, but now when I activate the client it tries repeatly to talk to the master to get the stream, but errors out with the message ...

FATAL: no pg_hba.conf entry for replication connection from host "xxx.xxx.xxx.xxx", user "postgres", SSL off

Edit/Delete Message Reply With Quote Quick reply to this message