Thanks Michael, Could you please tell me how I can get LSN of each transaction at decoder plugin?
On Wed, Aug 3, 2016 at 2:08 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Wed, Aug 3, 2016 at 3:00 PM, Michael Paquier > <michael.paqu...@gmail.com> wrote: > > On Wed, Aug 3, 2016 at 12:37 PM, Joshua Bay <joshuaba...@gmail.com> > wrote: > >> 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. > > > > Logical decoding is one way. > > And I just saw your other message... What I just meant here is that if > you use a decoder plugin that just emits information at transaction > begin/commit you can directly get this information. There is no need > to directly look at the WAL logs, the server does it for you. And it > offers a good cover regarding the information that has already been > consumed or not. > > (Btw, avoid sending emails across multiple mailing lists, particularly > pgsql-committers which is not aimed for that). > -- > Michael >