obsolete pg_receivexlog note?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: obsolete pg_receivexlog note?
Date: 2014-10-20 18:07:03
Message-ID: 54454F47.50407@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Dag-Erling Smørgrav 2014-10-20 19:39:37 Re: [PATCH] fix tool list for FreeBSD
Previous Message Peter Eisentraut 2014-10-20 18:04:39 9.4 recommendations for archive_command vs. replication slots