Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42133=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WALK9-0005LF-PW
 for pgsql-admin@arkaria.postgresql.org; Mon, 03 Feb 2014 15:20:37 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42133=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WALK9-0002cY-4z
 for pgsql-admin@arkaria.postgresql.org; Mon, 03 Feb 2014 15:20:37 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scott_ribe@elevated-dev.com>) id 1WALK8-0002cR-42
 for pgsql-admin@postgresql.org; Mon, 03 Feb 2014 15:20:36 +0000
Received: from mailout1.easymail.ca ([64.68.200.113]
 helo=mailout4.easymail.ca)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scott_ribe@elevated-dev.com>) id 1WALK4-0000gD-OY
 for pgsql-admin@postgresql.org; Mon, 03 Feb 2014 15:20:35 +0000
Received: from localhost (localhost [127.0.0.1])
 by mailout4.easymail.ca (Postfix) with ESMTP id 1516EE1B3;
 Mon,  3 Feb 2014 10:20:30 -0500 (EST)
X-Virus-Scanned: Debian amavisd-new at mailout4.easymail.ca
Received: from mailout4.easymail.ca ([127.0.0.1])
 by localhost (easymail-mailout2.easydns.vpn [127.0.0.1]) (amavisd-new,
 port 10024)
 with ESMTP id LbqaHP0IIpD6; Mon,  3 Feb 2014 10:20:28 -0500 (EST)
Received: from [192.168.2.118] (65-128-19-118.hlrn.qwest.net [65.128.19.118])
 (using TLSv1 with cipher AES128-SHA (128/128 bits))
 (No client certificate requested)
 by mailout4.easymail.ca (Postfix) with ESMTPSA id 47391E1AE;
 Mon,  3 Feb 2014 10:20:26 -0500 (EST)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\))
Subject: Re: Cannot change archive_command with a reload
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAKoxK+5xY-EgFqZYjE8STpsNQFiOfyZ7JjCiEunTCM2g3iHN_g@mail.gmail.com>
Date: Mon, 3 Feb 2014 08:20:24 -0700
Cc: CS DBA <cs_dba@consistentstate.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: 7bit
Message-Id: <82ED2269-2CC0-4652-9917-05BF1FFDE18B@elevated-dev.com>
References: <52EE69AF.4030709@consistentstate.com>
 <CA+h6AhgvJTdb41peyGFeOnpigG6uzJQbH7iZaDRfoWuT+wQ+YA@mail.gmail.com>
 <52EE71B9.3090204@consistentstate.com>
 <CA+h6Ahhu+PRLWjQeHCSwmKKk1UuSj-aiqK0cmqRzeSw9gojFsg@mail.gmail.com>
 <52EE78EA.7070801@consistentstate.com>
 <CAKoxK+5xY-EgFqZYjE8STpsNQFiOfyZ7JjCiEunTCM2g3iHN_g@mail.gmail.com>
To: Luca Ferrari <fluca1978@infinito.it>
X-Mailer: Apple Mail (2.1827)
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Feb 3, 2014, at 8:15 AM, Luca Ferrari <fluca1978@infinito.it> wrote:

> As explained by others, the issue of having partial files is not an
> issue at all.

It most certainly is an issue--the cp command is not atomic.

-- 
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin