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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Way to access LSN (for each transaction) by directly talking to postgres?
Дата
Msg-id CAMsr+YHCRG84h8Xr=D-C+MF5N8-DC-aXqpVVcroSfP4Pmy8+Kg@mail.gmail.com
обсуждение исходный текст
Ответ на Way to access LSN (for each transaction) by directly talking to postgres?  (Joshua Bay <joshuabay93@gmail.com>)
Ответы Re: Way to access LSN (for each transaction) by directly talking to postgres?  (Joshua Bay <joshuabay93@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Why we lost Uber as a user
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Detecting skipped data from logical slots (data silently skipped)