Re: Reliable WAL file shipping over unreliable network

From: Ray Stell <stellr(at)vt(dot)edu>
To: Nagy László Zsolt <gandalf(at)shopzeus(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Reliable WAL file shipping over unreliable network
Date: 2018-02-28 15:21:47
Message-ID: 3c9f0338-631c-ed8f-a7a1-e1bf7d69b4a7@vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2/28/18 9:57 AM, Nagy László Zsolt wrote:

> but
> am I right in that I can combine log file shipping with streaming
> replication, and achieve small replication delays plus the ability to
> recover after a longer period if network outage?
>
yes.

You might look at adjusting your wal_keep_segments to retain WAL for a
period longer than expected network failures.  This might require some
storage planning/adjustments.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nagy László Zsolt 2018-02-28 15:23:01 Re: Reliable WAL file shipping over unreliable network
Previous Message scott ribe 2018-02-28 15:12:50 Re: Reliable WAL file shipping over unreliable network