Horton

Re: Streaming replication and WAL archive interactions

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: hlinnaka <hlinnaka@iki.fi>
Cc: Michael Paquier <michael.paquier@gmail.com>, Venkata Balaji N <nag1010@gmail.com>, Andres Freund <andres@anarazel.de>, Fujii Masao <masao.fujii@gmail.com>, Borodin Vladimir <root@simply.name>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2015-05-13T13:29:49Z
Lists: pgsql-hackers 
On Wed, May 13, 2015 at 8:53 AM, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> Our manual says that archive_command should refuse to overwrite an existing
> file. But to work-around the double-archival problem, where the same file is
> archived twice, it would be even better if it would simply return success if
> the file exists, *and has identical contents*. I don't know how to code that
> logic in a simple one-liner though.

This is why we really, really need that pg_copy command that was
proposed a while back.

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