Sorry I forgot to reply. Thanks! using decoding plugins works great On Wed, Aug 3, 2016 at 8:37 PM, Michael Paquier <michael.paqu...@gmail.com> wrote:
> On Thu, Aug 4, 2016 at 3:02 AM, Joshua Bay <joshuaba...@gmail.com> wrote: > > Could you please tell me how I can get LSN of each transaction at decoder > > plugin? > > Craig already gave you hints, but here are more. You will need to hack > your own plugin. You could just use the one in contrib/test_decoding, > remove most of its code, and use the commit callback to issue the LSN > you are interested in. Note as well that when using > pg_logical_slot_peek_changes or pg_logical_slot_get_changes, you can > get a LSN location. Using test_decoding as a base, that's not a > complicated effort. > -- > Michael >