Re: [PATCHES] odd output in restore mode - Mailing list pgsql-hackers

From Greg Smith
Subject Re: [PATCHES] odd output in restore mode
Date
Msg-id Pine.GSO.4.64.0807281136140.26479@westnet.com
Whole thread Raw
In response to Re: [PATCHES] odd output in restore mode  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: [PATCHES] odd output in restore mode
List pgsql-hackers
On Wed, 23 Jul 2008, Kevin Grittner wrote:

> 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?

This is exactly what I always do.  I think the way cp is shown in the
examples promotes what's really a bad practice for lots of reasons, this
particular problem being just one of them.

I've been working on an improved archive_command shell script that I
expect to submit for comments and potential inclusion in the documentation
as a better base for other people to build on.  This is one of the options
for how it can operate.  It would be painful but not impossible to convert
a subset of that script to run under Windows as well, at least enough to
cover this particular issue.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Do we really want to migrate plproxy and citext intoPG core distribution?
Next
From: Andrew Dunstan
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?