pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Steele <david@pgmasters.net>
To: Stephen Frost <sfrost@snowman.net>
To: Rui DeSousa <rui.desousa@icloud.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Reliable WAL file shipping over unreliable network
Date: Tue, 6 Mar 2018 14:31:55 -0500
Message-ID: <68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net> (raw)
In-Reply-To: <20180306190004.GQ2416@tamriel.snowman.net>
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>

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 to an NFS mount or a tape library.  Even Barman recommends rsync with the archive_command; if you are unable to use pg_receivexlog solution.  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

Attachments:

  signature.asc (application/pgp-signature, 873B) download

view thread (59+ messages)  latest in thread

Message-ID: <68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net>
Permalink:  ../68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net/
Also on:    postgresql.org/message-id/68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: david@pgmasters.net, sfrost@snowman.net, rui.desousa@icloud.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Reliable WAL file shipping over unreliable network
  In-Reply-To: <68099b52-3909-07e3-04ea-b5ba600b1767@pgmasters.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox