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

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Rui DeSousa <rui.desousa@icloud.com>
Cc: scott ribe <scott_ribe@elevated-dev.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: Dianne Skoll <dfs@roaringpenguin.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Reliable WAL file shipping over unreliable network
Date: Mon, 5 Mar 2018 06:15:21 -0500
Message-ID: <20180305111521.GV2416@tamriel.snowman.net> (raw)
In-Reply-To: <3D9CC2FB-57E1-45B2-B5FC-1B214F5DB068@icloud.com>
References: <9DDA6F85-077E-4F8D-8708-632CC2907D3C@icloud.com>
	<06dd8b81-8b1a-ae5c-8ddd-1556b5946176@catalyst.net.nz>
	<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>

Greetings,

* Rui DeSousa (rui.desousa@icloud.com) wrote:
> In that case I suggest reading up on replication slots and pg_receievexlog.  Everyone’s tropology and requirements are different and there are many ways to skin a cat. 

Please don't top-post.

Using replication slots and pg_receivewal can be a good solution if
you're on a version which supports the combination of both.  That
doesn't mean the proposed archive commands are any good though, just to
be clear.  An issue with pg_receivewal though is that it's
single-threaded.

Thanks!

Stephen

Attachments:

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

view thread (59+ messages)  latest in thread

Message-ID: <20180305111521.GV2416@tamriel.snowman.net>
Permalink:  ../20180305111521.GV2416@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20180305111521.GV2416@tamriel.snowman.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: sfrost@snowman.net, rui.desousa@icloud.com, scott_ribe@elevated-dev.com, mark.kirkwood@catalyst.net.nz, dfs@roaringpenguin.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Reliable WAL file shipping over unreliable network
  In-Reply-To: <20180305111521.GV2416@tamriel.snowman.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