Dealing with latency to replication slave; what to do?

From: Rory Falloon <rfalloon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dealing with latency to replication slave; what to do?
Date: 2018-07-24 19:39:32
Message-ID: CANP_6+NnvGQtChT8HPDDpdHW-yt-OHjNdQk9nPY2iUoOs6qRKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Looking for any tips here on how to best maintain a replication slave which
is operating under some latency between networks - around 230ms. On a good
day/week, replication will keep up for a number of days, but however, when
the link is under higher than average usage, keeping replication active can
last merely minutes before falling behind again.

2018-07-24 18:46:14 GMTLOG: database system is ready to accept read only
connections
2018-07-24 18:46:15 GMTLOG: started streaming WAL from primary at
2B/93000000 on timeline 1
2018-07-24 18:59:28 GMTLOG: incomplete startup packet
2018-07-24 19:15:36 GMTLOG: incomplete startup packet
2018-07-24 19:15:36 GMTLOG: incomplete startup packet
2018-07-24 19:15:37 GMTLOG: incomplete startup packet

As you can see above, it lasted about half an hour before falling out of
sync.

On the master, I have wal_keep_segments=128. What is happening when I see
"incomplete startup packet" - is it simply the slave has fallen behind,
and cannot 'catch up' using the wal segments quick enough? I assume the
slave is using the wal segments to replay changes and assuming there are
enough wal segments to cover the period it cannot stream properly, it will
eventually recover?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Márcio Antônio Sepp 2018-07-24 19:41:47 RES: How can i install contrib modules in pg11 via source
Previous Message Adrian Klaver 2018-07-24 19:08:47 Re: How can i install contrib modules in pg11 via source