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

> On Nov 8, 2021, at 11:47, Oleg Serov <oleg@slapdash.com> wrote:
> I'm sorry, when I mean users, I mean application end-user (e.g. john@doe.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.