Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C2E8D6500C9; Wed, 23 Jul 2008 18:01:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71296-08; Wed, 23 Jul 2008 18:01:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from alexis.jtlnet.com (alexis.jtlnet.com [69.36.9.81]) by postgresql.org (Postfix) with ESMTP id DB3E464FCCC; Wed, 23 Jul 2008 18:01:23 -0300 (ADT) Received: from [192.168.10.103] (cpe-075-177-154-079.nc.res.rr.com [::ffff:75.177.154.79]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by alexis.jtlnet.com with esmtp; Wed, 23 Jul 2008 16:55:26 -0400 id 00087DE8.48879ABE.0000100A Message-ID: <48879C1E.9090600@dunslane.net> Date: Wed, 23 Jul 2008 17:01:18 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.0.9-3.fc6 pango-text SeaMonkey/1.0.9 MIME-Version: 1.0 To: Kevin Grittner CC: Simon Riggs , Heikki Linnakangas , Bruce Momjian , Dave Page , PostgreSQL-development , List pgsql-patches , Martin Zaun Subject: Re: [PATCHES] odd output in restore mode References: <200807011520.m61FKhZ20311@momjian.us> <48867904.9090001@sun.com> <1216810783.3894.602.camel@ebony.2ndQuadrant> <48877AC0.7070603@enterprisedb.com> <48873C7E.EE98.0025.0@wicourts.gov> In-Reply-To: <48873C7E.EE98.0025.0@wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/1098 X-Sequence-Number: 121358 Kevin Grittner wrote: >>>> "Heikki Linnakangas" wrote: >>>> > > >> We really need a more reliable way of detecting that a file has been >> > > >> fully copied. >> > > In our scripts we handle this by copying to a temp directory on the > same mount point as the archive directory and doing a mv to the > archive location when the copy is successfully completed. I think > that this even works on Windows. Could that just be documented as a > strong recommendation for the archive script? > > > > Needs testing at least. If it does in fact work then we can just adjust the docs and be done - or maybe provide a .bat file or perl script that would work as na archive_command on Windows. cheers andrew