obsolete pg_receivexlog note?
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
On 10/20/14 2:07 PM, Peter Eisentraut wrote:
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.
Here is a patch.
Attachments:
pg-receivexlog-notes.patchapplication/x-patch; name=pg-receivexlog-notes.patchDownload+6-11
On Thu, Nov 6, 2014 at 6:42 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
On 10/20/14 2:07 PM, Peter Eisentraut wrote:
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.Here is a patch.
In this paragraph, is it worth mentioning as well that the tradeoff
when using replication slots is to monitor the xlog partition to be
sure it doesn't get full?
--
Michael
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
On 11/5/14 6:54 PM, Michael Paquier wrote:
In this paragraph, is it worth mentioning as well that the tradeoff
when using replication slots is to monitor the xlog partition to be
sure it doesn't get full?
Might as well.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
On 11/5/14 7:36 PM, Peter Eisentraut wrote:
On 11/5/14 6:54 PM, Michael Paquier wrote:
In this paragraph, is it worth mentioning as well that the tradeoff
when using replication slots is to monitor the xlog partition to be
sure it doesn't get full?Might as well.
Committed.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
On Sat, Nov 8, 2014 at 10:30 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
On 11/5/14 7:36 PM, Peter Eisentraut wrote:
On 11/5/14 6:54 PM, Michael Paquier wrote:
In this paragraph, is it worth mentioning as well that the tradeoff
when using replication slots is to monitor the xlog partition to be
sure it doesn't get full?Might as well.
Committed.
Thanks for adding a note about partitions that may get full.
--
Michael
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs