Re: Question: Is it possible to get the new xlog position after query execution?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Oleg Serov <oleg(at)slapdash(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Question: Is it possible to get the new xlog position after query execution?
Date: 2021-11-08 17:11:15
Message-ID: CF73DC8D-118F-4777-82E4-599EBC0FB64E@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Nov 7, 2021, at 19:42, Oleg Serov <oleg(at)slapdash(dot)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 that once the transaction is committed, the secondary has it.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Serov 2021-11-08 18:03:32 Re: Question: Is it possible to get the new xlog position after query execution?
Previous Message Adrian Klaver 2021-11-08 16:25:42 Re: Design database schemas around a common subset of objects