From: | Ganesh Korde <ganeshakorde(at)gmail(dot)com> |
---|---|
To: | johannes(at)truschnigg(dot)info |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Streaming replication connection break - unexpected EOF on standby connection |
Date: | 2018-06-28 10:08:38 |
Message-ID: | CAPNyb0V=J+8JAFY4YDJYRs+SyyXqgVEcTwn7yba3ORrjZ1uhbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Johannes,
Thanks for your reply. We are using VPN Tunnel between these two hosts. I
will check with network team, with remaining questions you mentioned and
will get back.
Thanks & Regards,
Ganesh.
On Wed, Jun 27, 2018 at 6:46 PM Johannes Truschnigg <
johannes(at)truschnigg(dot)info> wrote:
> Hi Ganesh,
>
>
> On Wed, Jun 27, 2018 at 06:37:25PM +0530, Ganesh Korde wrote:
> > [...]
> > 1. Because of what reason, " unexpected EOF on standby connection" occurs
> > on primary db server?
> > 2. After replication disconnection, secondary should immediately connect
> to
> > primary, but it takes some time, what could be the reason for this?
>
> From skimming the log, it seems to me that there is an issue at the
> socket/network level, which yields the "connection reset by peer" eror
> message.
>
> What is the network between these two hosts like? Is it a WAN link; is a
> VPN
> or SSH tunnel involved? Do you have other, long-running TCP sessions
> between
> these peers, and do they experience similar or other problems? Do the
> hosts'
> link-layer stats hint at problems, e. g. packet loss? Do the hosts' kernels
> leave a message hinting at L2 connectivity problems in their debug
> ringbuffers
> (`dmesg`) at the time you observe the replication drop out?
>
> --
> with best regards:
> - Johannes Truschnigg ( johannes(at)truschnigg(dot)info )
>
> www: https://johannes.truschnigg.info/
> phone: +43 650 2 133337
> xmpp: johannes(at)truschnigg(dot)info
>
> Please do not bother me with HTML-email or attachments. Thank you.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Bashtanov | 2018-06-28 13:10:51 | Re: Server Crash |
Previous Message | John Scalia | 2018-06-27 19:53:20 | Re: Upgrading 9.6.9 to 10.4 |