Re: Way to access LSN (for each transaction) by directly talking to postgres?

Поиск
Список
Период
Сортировка
От Joshua Bay
Тема Re: Way to access LSN (for each transaction) by directly talking to postgres?
Дата
Msg-id CABb-U3axvtZKEKr1VT-CTDwFton8jLPEQvydWN4vL-ZODp4g8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Way to access LSN (for each transaction) by directly talking to postgres?  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: Way to access LSN (for each transaction) by directly talking to postgres?  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
Thanks for responses!

The problem I wanted to solve was to find the (global) order of commits across the postgres cluster. So, my attempt was to use the LSN.



On Wed, Aug 3, 2016 at 9:47 AM, Craig Ringer <craig@2ndquadrant.com> wrote:


On 3 August 2016 at 11:37, Joshua Bay <joshuabay93@gmail.com> wrote:
Hi,

Could you please let me know if there is a way to get LSN of each transaction by directly communicating with Postgres server and NOT by accessing logs.


To what end? What problem are you trying to solve?

What LSN, exactly? The LSN of the first write and xid allocation? The LSN of the commit record? What if it's a complex commit like with prepared xacts?


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Increasing timeout of poll_query_until for TAP tests
Следующее
От: Andrey Borodin
Дата:
Сообщение: Re: Optimizing numeric SUM() aggregate