Re: Streaming replication and WAL archive interactions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Streaming replication and WAL archive interactions
Date
Msg-id CA+TgmoY7wkYi-27LOnm128RRw8cQ=tNhJdPGgJ0JgpQZ-uwUuA@mail.gmail.com
Whole thread Raw
In response to Re: Streaming replication and WAL archive interactions  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On Tue, Apr 21, 2015 at 8:30 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> This .partial segment renaming is something that we
> should let the archive_command manage with its internal logic.

This strikes me as equivalent to saying "we don't know how to make
this work right, but maybe our users will know".  That never works
out.  As things stand, we have a situation where the archive_command
examples in our documentation are known to be flawed.  They don't
fsync the file, and they'll write a partial file and then, when rerun,
fail to copy the full file because there's already something there.
Efforts have been made to fix these problems (see the pg_copy thread),
but they haven't been completed yet, nor have we even documented the
issues with the commands recommended by the documentation.  Let's
please not throw anything else on the pile of things we're expecting
users to somehow "get right".

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Turning off HOT/Cleanup sometimes
Next
From: Heikki Linnakangas
Date:
Subject: Re: Streaming replication and WAL archive interactions