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 20:03:32
Message-ID: A053A2FC-CAE0-4AC3-B298-FCEAFB755EE8@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Nov 8, 2021, at 11:47, Oleg Serov <oleg(at)slapdash(dot)com> wrote:
> I'm sorry, when I mean users, I mean application end-user (e.g. john(at)doe(dot)com), not the postgres role.

You can also set it as a session-level variable. :-)

SET synchronous_commit = 'on';

You could flip it on for the application-level users that require it, only when it is required.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Akheel Ahmed 2021-11-09 00:51:27 Zero Downtime Upgrade
Previous Message Oleg Serov 2021-11-08 19:47:23 Re: Question: Is it possible to get the new xlog position after query execution?