Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XGrQc-0001y6-1z for pgsql-docs@arkaria.postgresql.org; Mon, 11 Aug 2014 15:22:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XGrQb-0004Uy-Hf for pgsql-docs@arkaria.postgresql.org; Mon, 11 Aug 2014 15:22:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XFtnO-0006dh-BJ for pgsql-docs@postgresql.org; Fri, 08 Aug 2014 23:42:02 +0000 Received: from mx-out.zmailcloud.com ([192.198.85.98] helo=mx-out-1.zmailcloud.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XFtnG-0000C7-1D for pgsql-docs@postgresql.org; Fri, 08 Aug 2014 23:42:01 +0000 Received: from smtp.01.com (smtp.01.com [10.10.0.43]) by mx-out-1.zmailcloud.com (Postfix) with ESMTP id 25F8E5663B6 for ; Fri, 8 Aug 2014 18:41:52 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 21E6060364 for ; Fri, 8 Aug 2014 18:41:52 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id AB7Z6pTJnjeH for ; Fri, 8 Aug 2014 18:41:52 -0500 (CDT) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 046936036A for ; Fri, 8 Aug 2014 18:41:52 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id E311260364 for ; Fri, 8 Aug 2014 18:41:51 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id LTgLWXnCDENP for ; Fri, 8 Aug 2014 18:41:51 -0500 (CDT) Received: from [172.47.23.104] (70-36-143-82.dsl.dynamic.sonic.net [70.36.143.82]) by smtp-out-2.01.com (Postfix) with ESMTPSA id 998FB60376 for ; Fri, 8 Aug 2014 18:41:51 -0500 (CDT) Message-ID: <53E5603B.5040102@agliodbs.com> Date: Fri, 08 Aug 2014 16:41:47 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Sample archive_command is still problematic Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org All: The example archive_command we give in the docs is this one: archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' This is a problematic recommendation. If there's any reason why copying the archive file gets interrupted (storage blip, for example), then the command will fail and will continue to fail forever, ending archiving. Is there some good reason why "test ! -f" was added to the sample? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs