On Fri, May 08, 2020 at 03:02:26PM +0500, godjan • wrote: > Can you recommend what to use to determine which quorum standby > should be promoted in such case? > We planned to use pg_last_wal_receive_lsn() to determine which has > fresh data but if it returns the beginning of the segment on both > replicas we can’t determine which standby confirmed that write > transaction to disk.
If you want to preserve transaction-level consistency across those notes, what is your configuration for synchronous_standby_names and synchronous_commit on the primary? Cannot you rely on that? -- Michael
signature.asc
Description: PGP signature
