Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Tomas Vondra
On Sun, Sep 15, 2019 at 09:44:14AM -0600, Michael Loftis wrote: On Sun, Sep 15, 2019 at 08:36 Virendra Negi wrote: Oh I miss the documentation link there you go https://www.postgresql.org/docs/9.5/protocol-replication.html On Sun, Sep 15, 2019 at 8:05 PM Virendra Negi wrote: Agreed but why

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Jeff Janes
On Sun, Sep 15, 2019 at 11:44 AM Michael Loftis wrote: > > > On Sun, Sep 15, 2019 at 08:36 Virendra Negi wrote: > >> Oh I miss the documentation link there you go >> https://www.postgresql.org/docs/9.5/protocol-replication.html >> >> On Sun, Sep 15, 2019 at 8:05 PM Virendra Negi >> wrote: >> >>

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Michael Loftis
On Sun, Sep 15, 2019 at 08:36 Virendra Negi wrote: > Oh I miss the documentation link there you go > https://www.postgresql.org/docs/9.5/protocol-replication.html > > On Sun, Sep 15, 2019 at 8:05 PM Virendra Negi > wrote: > >> Agreed but why is there a message specification for it describe in th

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Virendra Negi
Oh I miss the documentation link there you go https://www.postgresql.org/docs/9.5/protocol-replication.html On Sun, Sep 15, 2019 at 8:05 PM Virendra Negi wrote: > Agreed but why is there a message specification for it describe in the > documentation and it ask to client reply back if a particul

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Virendra Negi
Agreed but why is there a message specification for it describe in the documentation and it ask to client reply back if a particular *bit* is set.(1 means that the client should reply to this message as soon as possible, to avoid a timeout disconnect. 0 otherwise) Primary keepalive message (B) B

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-15 Thread Michael Loftis
On Fri, Sep 13, 2019 at 07:12 Virendra Negi wrote: > Implemented the Logical Streaming Replication thing are working fine I see > the XLogData message appearing and I'm able to parse them. > > But I haven't see any "Primary Keepalive message" yet. I had tried > setting the *tcp_keepalive_interva

Re: Primary keepalive message not appearing in Logical Streaming Replication

2019-09-14 Thread Virendra Negi
I forgot to mention the plugin I have been using along with logical replication its wal2json. On Friday, September 13, 2019, Virendra Negi wrote: > Implemented the Logical Streaming Replication thing are working fine I see > the XLogData message appearing and I'm able to parse them. > > But I h

Primary keepalive message not appearing in Logical Streaming Replication

2019-09-13 Thread Virendra Negi
Implemented the Logical Streaming Replication thing are working fine I see the XLogData message appearing and I'm able to parse them. But I haven't see any "Primary Keepalive message" yet. I had tried setting the *tcp_keepalive_interval*, *tcp_keepalives_idle* both from client runtime paramter an