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

From David Steele
Subject Re: Reliable WAL file shipping over unreliable network
Date
Msg-id 68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net
Whole thread Raw
In response to Re: Reliable WAL file shipping over unreliable network  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Reliable WAL file shipping over unreliable network  (Johannes Truschnigg <johannes@truschnigg.info>)
Re: Reliable WAL file shipping over unreliable network  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-admin
On 3/6/18 2:00 PM, Stephen Frost wrote:
>
> * Rui DeSousa (rui.desousa@icloud.com) wrote:
>>> On Mar 5, 2018, at 10:02 AM, Stephen Frost <sfrost@snowman.net> wrote:
>>> It doesn’t- but please don't encourage partial solutions which have ver clear issues.
>>
>> Then problem is there are no good base utilities that is useful with archive_command; unless you’re writing directly
toan NFS mount or a tape library.  Even Barman recommends rsync with the archive_command; if you are unable to use
pg_receivexlogsolution.  There are countless Postgres documentation out there that recommends use of rsync with the
archive_command.  
>>
>> Here a solution that will fsync() file on the other end.
>
> I'd encourage you to consider submitting this to a commitfest to get
> feedback on it, as a proper patch to add such a utlity to PG and which
> we could use in our documentation instead of saying "cp", which is
> pretty terrible.

+1.  I believe there's been talk of a pgcopy utility before but it never
went anywhere.  I think it would be worth it just to have a decent
example in the docs.

--
-David
david@pgmasters.net


Attachment

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Reliable WAL file shipping over unreliable network
Next
From: Johannes Truschnigg
Date:
Subject: Re: Reliable WAL file shipping over unreliable network