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

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Question: Is it possible to get the new xlog position after query execution?
Дата
Msg-id A053A2FC-CAE0-4AC3-B298-FCEAFB755EE8@thebuild.com
обсуждение исходный текст
Ответ на Re: Question: Is it possible to get the new xlog position after query execution?  (Oleg Serov <oleg@slapdash.com>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Oleg Serov
Дата:
Сообщение: Re: Question: Is it possible to get the new xlog position after query execution?
Следующее
От: Akheel Ahmed
Дата:
Сообщение: Zero Downtime Upgrade