Sample Header Ad - 728x90

what after WAL LSN value of type pg_lsn reach its limit

1 vote
2 answers
792 views
I am trying to determine the optimal Standby for automated failover based on the highest value of pg_last_wal_receive_lsn() of all slaves. But what if max_wal_size is reached, does pg_lsn values go to 0? Please suggest if there's any better approach to determine node with the best RPO out of all secondaries.
Asked by Lucky Shofar (13 rep)
Oct 27, 2022, 08:33 AM
Last activity: Jun 17, 2023, 06:33 AM