Re: Reliable WAL file shipping over unreliable network

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: David Steele <david(at)pgmasters(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, Rui DeSousa <rui(dot)desousa(at)icloud(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Reliable WAL file shipping over unreliable network
Date: 2018-03-07 21:01:53
Message-ID: 8aae595d-e748-f41d-e452-186fb5b00ce2@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 07/03/18 16:18, Mark Kirkwood wrote:

>
>
> The added (new) issue that there may be some unusual bug with rsync +
> quotas and ZFS on BSD (at least) gives a bit more weight to this idea.
>
>
>

Looking at the progress of said bug
(https://bugzilla.samba.org/show_bug.cgi?id=13317) it appears to be:

- due interaction of ZFS and quotas
- specific to Freebsd
- patch has been developed

However, code review of rsync shows it needs a patch too (not always
checking success of writes). I'll keep an eye out for progress there.

regards
Mark

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2018-03-07 21:08:05 Update overwriting
Previous Message bricklen 2018-03-07 20:21:23 Re: pg_upgrade and frozen xids