From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-docs <pgsql-docs@postgresql.org>
Subject: obsolete pg_receivexlog note?
Date: Mon, 20 Oct 2014 14:07:03 -0400
Message-ID: <54454F47.50407@gmx.net> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
The reference page for pg_receivexlog
(http://www.postgresql.org/docs/9.4/static/app-pgreceivexlog.html) has
this note:
"""
When using pg_receivexlog instead of archive_command, the server will
continue to recycle transaction log files even if the backups are not
properly archived, since there is no command that fails. This can be
worked around by having an archive_command that fails when the file has
not been properly archived yet, for example:
archive_command = 'sleep 5 && test -f /mnt/server/archivedir/%f'
The initial timeout is necessary because pg_receivexlog works using
asynchronous replication and can therefore be slightly behind the master.
"""
ISTM that this should be replaced with something to the effect of, if
you are using pg_receivexlog instead of archive_command, you had better
use slots.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: peter_e@gmx.net
Subject: Re: obsolete pg_receivexlog note?
In-Reply-To: <54454F47.50407@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox