Read Only Inactive

Read Only Inactive

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

                  New to ADSelfService Plus?