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 1esVDp-0007YV-8b for pgsql-admin@arkaria.postgresql.org; Sun, 04 Mar 2018 15:06:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1esVDo-00006J-8j for pgsql-admin@arkaria.postgresql.org; Sun, 04 Mar 2018 15:06:44 +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 1esVDn-00006A-U4 for pgsql-admin@lists.postgresql.org; Sun, 04 Mar 2018 15:06:44 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1esVDl-0006Dl-36 for pgsql-admin@lists.postgresql.org; Sun, 04 Mar 2018 15:06:42 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 497795F79C; Sun, 4 Mar 2018 10:06:40 -0500 (EST) Date: Sun, 4 Mar 2018 10:06:40 -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: <20180304150640.GR2416@tamriel.snowman.net> References: <21AF0CB4-0873-4960-BA14-E72FA08B352E@icloud.com> <5a49c387-e4f4-f70c-537c-9c338c80b687@catalyst.net.nz> <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> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="m67jHghVWuEStad9" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --m67jHghVWuEStad9 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Rui DeSousa (rui.desousa@icloud.com) wrote: > Not a problem; as you should be archiving your WALs to multiple sites sim= ultaneously. You=E2=80=99re DR site should not rely on any resources store= d at the primary site. Please don't top-post on the PG mailing lists. We prefer in-line responses, such as this. I agree that archiving WAL to multiple sites is a good idea, but none of the proposed examples does that or even provides a way to easily and reliably do it, so that doesn't actually address the issue. Thanks! Stephen --m67jHghVWuEStad9 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJanAuAAAoJEO1sijiDR2RVvUsP/1pwvw66ScFO630ZWbdzQ6OE /38jD5XasGa1TMseoV0Lk2inNU585dS0k+ViZ/65FGRihOeSRX7E6dgk0t/XdbNm zoYoVMvRrrtGhgnOzsBwVx8/WS1lPl8i+VLegE72faGCzNf28KZ2M6HqM269yPEU V2MrHdb4BDQ5c1tuoLSRboH2mL6rcmLiXCVkBg5BnlFCeNImFGlPjEOnKLQfJDqn AXmbT8TqxR+Mi6fCqDFuq0wDsyupxMhqcvE0iPb7t87AOILEKhSBp/BfpNmEjD6k pmaCteRisIV6MX4WhptT7uqR6ZfEfymDZ8uafLOaiHCwmOOrQmecgMNpjWEQWcWP PmJhuo3FFm4+O00L0fYobH8Fho6dQeDsWf26La0yGA4JZfVgtI/dmEYFZ9z2/RVj 8FQm1KSbb3AxxHfxyLUFFDQ+3NwAf0mIugVq4dKUqkFpWpDuptyLZtq3/2W16XOm /3v8QyJVd6bq9enNUaPrdZkRN4lea9NGemojsU1eift8zs9ZrEVjdRlEdSsGzH+v AIMD7PxHMzPqGTJjsu5LV59w3Dlqv1RpnkT6RGVIGNBxUTxDhFriKVa73TsctFY6 EHrozMnkmfFOWSV9RQV3ez+cSGw5jlj1Sn/fBWEWhHSuktNcFhKKnxEptUttGXH2 4pbVvhF8Ns0bKzQyOlO3 =aHRW -----END PGP SIGNATURE----- --m67jHghVWuEStad9--