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 ) id 1eso79-0004YT-34 for pgsql-admin@arkaria.postgresql.org; Mon, 05 Mar 2018 11:17:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eso78-0001YO-6D for pgsql-admin@arkaria.postgresql.org; Mon, 05 Mar 2018 11:17:06 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eso5W-0002jO-BS for pgsql-admin@lists.postgresql.org; Mon, 05 Mar 2018 11:15:26 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eso5S-0006Bp-Op for pgsql-admin@lists.postgresql.org; Mon, 05 Mar 2018 11:15:23 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id E40525F79C; Mon, 5 Mar 2018 06:15:21 -0500 (EST) Date: Mon, 5 Mar 2018 06:15:21 -0500 From: Stephen Frost To: Rui DeSousa Cc: scott ribe , Mark Kirkwood , Dianne Skoll , pgsql-admin@lists.postgresql.org Subject: Re: Reliable WAL file shipping over unreliable network Message-ID: <20180305111521.GV2416@tamriel.snowman.net> References: <9DDA6F85-077E-4F8D-8708-632CC2907D3C@icloud.com> <06dd8b81-8b1a-ae5c-8ddd-1556b5946176@catalyst.net.nz> <6056907B-551F-4ED0-804B-0FCACD39EB23@icloud.com> <988AB20C-9FDE-4197-BF3F-C54D80C2ED78@elevated-dev.com> <20180302180911.GO2416@tamriel.snowman.net> <20180304150640.GR2416@tamriel.snowman.net> <3D9CC2FB-57E1-45B2-B5FC-1B214F5DB068@icloud.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="WhkCIrS0gMNERM55" Content-Disposition: inline In-Reply-To: <3D9CC2FB-57E1-45B2-B5FC-1B214F5DB068@icloud.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --WhkCIrS0gMNERM55 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Rui DeSousa (rui.desousa@icloud.com) wrote: > In that case I suggest reading up on replication slots and pg_receievexlo= g. Everyone=E2=80=99s tropology and requirements are different and there a= re many ways to skin a cat.=20 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 --WhkCIrS0gMNERM55 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJanSbJAAoJEO1sijiDR2RVJ3EP/2dqBTPaYA9I96Re7QTsCKU9 R7jIvO45Q9NAZujAJzWdP+w+3Kwq90J1K53IXIr2PMuC0SsYZvPtjvXDx3vAsIlW yfRGm+ucokm2M5GIQCnDtaWEzfZ2jZyF2D+FSs4KIz9caVtYmYyrgLjpCDFKBeZX Fk2s8t6oFlYkItEc8PBYqb4fzn+KeyYA56iYDNvpkUwwSAVajapHmBaV8uE1h2w6 Sc60Gx9YQ2d6fF9u8MONAyoeT8SB3TLaxYdo78T/YDzoC5zxzytfKhUDm1fa6gE+ 2gWPPX8lCCnz0ecM6sSFxsxPBxCk/QozqMNYSaz4mxG82rUc8J2ZDk/Kr0/oapqD Wp3liAK+qf72KViXLfWA5Gg0WG7lgU8bFQywKDddPqmAKYkiaRRv3X2tavkih9a8 Cb/o6hx5yPqVn3xJ7G2xe3RcXb2tab7qNwlL5N1xajOY6hLHpjBKtw+gy5/a0eF5 XCyr/kftxw2T6GXpkAbyeIUbH5UGrfbZ/JhncQuoRWBd4YY4Ix4WWhyv7Y1zI9SI dxKZIJQB1GGW3TTYrRpwHk7u3odqMgNjHAd6PhDxFySO3HnRQW/oKzgH9gBJmm1r F5Fgu8gIXRpyemYXG+uHuaJd9qMz6dC/0+omfFiEOERjJ0u0TWWNIzUnh7GcCxdl N7Q2EJg2mp2AeztgzVlJ =d8cy -----END PGP SIGNATURE----- --WhkCIrS0gMNERM55--