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
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 |