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 CF73DC8D-118F-4777-82E4-599EBC0FB64E@thebuild.com
обсуждение исходный текст
Ответ на Re: Question: Is it possible to get the new xlog position after query execution?  (Oleg Serov <oleg@slapdash.com>)
Ответы Re: Question: Is it possible to get the new xlog position after query execution?
Список pgsql-general
Дерево обсуждения 

> 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Design database schemas around a common subset of objects
Следующее
От: Oleg Serov
Дата:
Сообщение: Re: Question: Is it possible to get the new xlog position after query execution?