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 1er67S-0007W6-B6 for pgsql-admin@arkaria.postgresql.org; Wed, 28 Feb 2018 18:06:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1er67R-0001x5-7n for pgsql-admin@arkaria.postgresql.org; Wed, 28 Feb 2018 18:06:21 +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 1er67Q-0001sl-S4 for pgsql-admin@lists.postgresql.org; Wed, 28 Feb 2018 18:06:21 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1er67N-00076n-Hp for pgsql-admin@lists.postgresql.org; Wed, 28 Feb 2018 18:06:19 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 829DBC05A4; Wed, 28 Feb 2018 18:06:15 +0000 (UTC) Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo01-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gPqbeyC90T2U; Wed, 28 Feb 2018 18:06:15 +0000 (UTC) Received: from shr-mbp-2.allegisgroup.com (unknown [216.152.106.23]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 365E9C03CB; Wed, 28 Feb 2018 18:06:11 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\)) Subject: Re: Reliable WAL file shipping over unreliable network From: scott ribe In-Reply-To: Date: Wed, 28 Feb 2018 11:05:19 -0700 Cc: =?utf-8?Q?Nagy_L=C3=A1szl=C3=B3_Zsolt?= , pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <400AC9CD-1E43-422C-A689-70BDBAFF231E@elevated-dev.com> To: Rui DeSousa X-Mailer: Apple Mail (2.3445.5.20) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Feb 28, 2018, at 10:05 AM, Rui DeSousa = wrote: >=20 > Just use "-ac=E2=80=9D; you want -c option to ensure no data = corruption during the transfer. Do not delete the file; let Postgres = manage that. -c has nothing to do with data corruption during transfer -- Scott Ribe https://www.linkedin.com/in/scottribe/ (303) 722-0567