Subject: Re: Reliable WAL file shipping over unreliable network
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: David Steele <david@pgmasters.net>, Stephen Frost <sfrost@snowman.net>,
 Rui DeSousa <rui.desousa@icloud.com>
Cc: pgsql-admin@lists.postgresql.org
References: <988AB20C-9FDE-4197-BF3F-C54D80C2ED78@elevated-dev.com>
 <E6AB850C-D05E-405B-8D4E-DE18E128F402@icloud.com>
 <20180302180911.GO2416@tamriel.snowman.net>
 <BB8E0E71-D65F-409F-B9AD-DDF2237CDF99@icloud.com>
 <20180304150640.GR2416@tamriel.snowman.net>
 <3D9CC2FB-57E1-45B2-B5FC-1B214F5DB068@icloud.com>
 <20180305111521.GV2416@tamriel.snowman.net>
 <ABC9F093-7249-498E-901B-6ADB7BBA3B22@icloud.com>
 <20180305150218.GY2416@tamriel.snowman.net>
 <15F9D550-9909-40B3-A384-417AFCD745DF@icloud.com>
 <20180306190004.GQ2416@tamriel.snowman.net>
 <68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net>
 <0bff7871-1f88-65a6-ac77-4bbba8f89889@catalyst.net.nz>
Message-ID: <8aae595d-e748-f41d-e452-186fb5b00ce2@catalyst.net.nz>
Date: Thu, 8 Mar 2018 10:01:53 +1300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <0bff7871-1f88-65a6-ac77-4bbba8f89889@catalyst.net.nz>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk

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