Hi,
I'm trying to configure a read only server but it always shows as inactive. I think I've followed the guide correctly except I do notice in
Read-Only Server guide under the troubleshooting section it says to check pg_hba.conf on the primary server that the primary and RO servers IP addresses are correct, can you confirm what it should look like please? I have entries in there but not 100% sure they are correct.
It also says on the RO server to check pg_hba.conf in <PMP_Installation_Folder>/conf but it doesn't exists in there, maybe it's a typo?
It then goes on to say check pg_hba.conf file for IP, Port, username, password and slot name. Could you give an example of what it should look like as mine has IP & username but none of the others.
If I check the log file in C:\Program Files\ManageEngine\PMP\pgsql\data\pg_log I see lots of these errors:
[2025-02-24 21:24:27.995 IST]|[1936]|STATEMENT: START_REPLICATION SLOT "srv100_ro_server" 4/7D000000 TIMELINE 1
[2025-02-24 21:24:32.988 IST]|[6312]|ERROR: requested WAL segment 00000001000000040000007D has already been removed
[2025-02-24 21:24:32.988 IST]|[6312]|STATEMENT: START_REPLICATION SLOT "srv100_ro_server" 4/7D000000 TIMELINE 1
[2025-02-24 21:24:38.002 IST]|[19984]|ERROR: requested WAL segment 00000001000000040000007D has already been removed
[2025-02-24 21:24:38.002 IST]|[19984]|STATEMENT: START_REPLICATION SLOT "srv100_ro_server" 4/7D000000 TIMELINE 1
Thanks