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

Sorry I forgot to reply. Thanks! using decoding plugins works great On Wed, Aug 3, 2016 at 8:37 PM, Michael Paquier wrote: > On Thu, Aug 4, 2016 at 3:02 AM, Joshua Bay wrote: > > Could you please tell me how I can get LSN of each transaction at

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

On Thu, Aug 4, 2016 at 3:02 AM, Joshua Bay 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

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

On 4 August 2016 at 01:35, Joshua Bay wrote: > 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. > Have a look at how logical decoding does it. Check out

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

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 wrote: > On Wed, Aug 3, 2016 at 3:00 PM, Michael Paquier > wrote: > > On Wed, Aug 3, 2016 at

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

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 wrote: > > > On 3 August 2016 at 11:37, Joshua Bay

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

On 3 August 2016 at 11:37, Joshua Bay 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

[HACKERS] Way to access LSN (for each transaction) by directly talking to postgres?

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. Thanks! Joshua

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

On Wed, Aug 3, 2016 at 3:00 PM, Michael Paquier wrote: > On Wed, Aug 3, 2016 at 12:37 PM, Joshua Bay 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

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

On Wed, Aug 3, 2016 at 12:37 PM, Joshua Bay 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. -- Michael -- Sent via