Postgres Pro
Downloads
Home   >   mailing lists

Re: Question: Is it possible to get the new xlog position after query execution? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Question: Is it possible to get the new xlog position after query execution?
Date
Msg-id CF73DC8D-118F-4777-82E4-599EBC0FB64E@thebuild.com
Whole thread Raw
In response to Re: Question: Is it possible to get the new xlog position after query execution?  (Oleg Serov <oleg@slapdash.com>)
Responses Re: Question: Is it possible to get the new xlog position after query execution?  (Oleg Serov <oleg@slapdash.com>)
List pgsql-general
Tree view 

> On Nov 7, 2021, at 19:42, Oleg Serov <oleg@slapdash.com> wrote:
> How would you accomplish this otherwise?

Synchronous commit.  It sounds like you are attempting to build the same kind of guarantees that synchronous commit
provides,only in the application by polling LSNs.  It might be best just to use synchronous commit, so that you know
thatonce the transaction is committed, the secondary has it.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Design database schemas around a common subset of objects
Next
From: Oleg Serov
Date:
Subject: Re: Question: Is it possible to get the new xlog position after query execution?