Re: Reliable WAL file shipping over unreliable network - Mailing list pgsql-admin

From Ray Stell
Subject Re: Reliable WAL file shipping over unreliable network
Date
Msg-id 3c9f0338-631c-ed8f-a7a1-e1bf7d69b4a7@vt.edu
Whole thread Raw
In response to Reliable WAL file shipping over unreliable network  (Nagy László Zsolt <gandalf@shopzeus.com>)
List 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.


pgsql-admin by date:

Previous
From: scott ribe
Date:
Subject: Re: Reliable WAL file shipping over unreliable network
Next
From: Nagy László Zsolt
Date:
Subject: Re: Reliable WAL file shipping over unreliable network