Re: Sample archive_command is still problematic

On 08/11/2014 03:23 PM, MauMau wrote:
> From: "Kevin Grittner" <kgrittn(at)ymail(dot)com>
> The problem with the recommended command is that cp is not atomic.
> The file can be read before the contents are materialized, causing
> early end to recovery. I have seen it happen. The right way to do
> this is to copy to a different name or directory and mv the file
> into place once it is complete -- or use software which does that
> automatically, like rsync does.
>
>
> I submitted a patch a patch for this a few months ago, which is pg_copy
> listed in the current CF. The patch also addresses the problem that the
> archived file can get lost after power failure because it is not flushed
> to disk. The patch consists of a program called pg_copy which can be
> used instead of cp/copy, and a doc fix to suggest using mv. I made it
> following the favorable suggestions from people.

Yah? Does it work on Windows?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com