pglogical lag due to replication timeout

From: greigwise <greigwise(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pglogical lag due to replication timeout
Date: 2018-03-12 18:33:52
Message-ID: 1520879632779-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all.

I've recently configured logical replication on postgres 9.6.5 using
pglogical 2.1.1.

The problem I'm seeing is pretty constant stream of these errors on the
service side in the postgres logs:

LOG: terminating walsender process due to replication timeout

After so many of these, I can see on the replication target side, that
things are not being updated. Eventually, the source server seems to retry
and then all the updates go through, but it seems like there's more lag than
there really should be due to all these "replication timeouts".

I'm not seeing anything on the network side, it's really a pretty fast
connection between the 2 servers, I can't see that being the issue. Plus I
have the wal_sender_timeout set to 600 (10 minutes) which seems like it
should be way overkill.

Any advice on this?

Thanks,
Greig Wise

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2018-03-12 20:18:22 Logical decoding on standby
Previous Message Ron Johnson 2018-03-12 18:32:24 Re: psql in a bash function