Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1etHnO-0004mc-R2
	for pgsql-admin@arkaria.postgresql.org; Tue, 06 Mar 2018 18:58:42 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1etHnN-0004gV-7y
	for pgsql-admin@arkaria.postgresql.org; Tue, 06 Mar 2018 18:58:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <david@pgmasters.net>)
	id 1etHnN-0004gH-0Y
	for pgsql-admin@lists.postgresql.org; Tue, 06 Mar 2018 18:58:41 +0000
Received: from mail.thelabyrinth.net ([45.56.70.56])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <david@pgmasters.net>)
	id 1etHnK-0007zZ-Ha
	for pgsql-admin@lists.postgresql.org; Tue, 06 Mar 2018 18:58:40 +0000
Received: from Davids-iMac.local (unknown [173.169.74.224])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	(Authenticated sender: dsteele)
	by mail.thelabyrinth.net (Postfix) with ESMTPSA id A7DD154683;
	Tue,  6 Mar 2018 18:58:36 +0000 (UTC)
Subject: Re: Reliable WAL file shipping over unreliable network
To: Rui DeSousa <rui.desousa@icloud.com>
Cc: Stephen Frost <sfrost@snowman.net>, pgsql-admin@lists.postgresql.org
References: <6056907B-551F-4ED0-804B-0FCACD39EB23@icloud.com>
 <ea674584-85bc-3f63-c182-0d45123bb3eb@catalyst.net.nz>
 <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>
 <b01c51be-2f5d-a158-7e8b-be39b5e99162@pgmasters.net>
 <3EF1FB1B-265A-4283-8201-0A4F99A4B699@icloud.com>
From: David Steele <david@pgmasters.net>
Message-ID: <1f90c51e-0f7a-1d67-c35a-90f42314cd79@pgmasters.net>
Date: Tue, 6 Mar 2018 13:58:35 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0)
 Gecko/20100101 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <3EF1FB1B-265A-4283-8201-0A4F99A4B699@icloud.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

On 3/6/18 1:53 PM, Rui DeSousa wrote:
> 
>> On Mar 6, 2018, at 1:47 PM, David Steele <david@pgmasters.net
>> <mailto:david@pgmasters.net>> wrote:
>>
>> It's true that there are no good base utilities for this purpose, not
>> sure why NFS would be an exception, though.
> 
> NFS file writes are synchronous writes on the NFS server — unless you
> make them asynchronous which makes for a bad NFS server.

In my experience this is common -- because it gives better performance
and most people don't understand the risks.

-- 
-David
david@pgmasters.net