Message-ID: <545A99AA.5020107@gmx.net>
Date: Wed, 05 Nov 2014 16:42:02 -0500
From: Peter Eisentraut <peter_e@gmx.net>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10;
 rv:31.0) Gecko/20100101 Thunderbird/31.2.0
MIME-Version: 1.0
To: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: obsolete pg_receivexlog note?
References: <54454F47.50407@gmx.net>
In-Reply-To: <54454F47.50407@gmx.net>
Content-Type: multipart/mixed; boundary="------------070504050403070009030104"
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

This is a multi-part message in MIME format.
--------------070504050403070009030104
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.


--------------070504050403070009030104
Content-Type: application/x-patch;
 name="pg-receivexlog-notes.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="pg-receivexlog-notes.patch"

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvcGdfcmVjZWl2ZXhsb2cu
c2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfcmVjZWl2ZXhsb2cuc2dtbApp
bmRleCAyYWIzOTJlLi5mOTBiNjFjIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3Nn
bWwvcmVmL3BnX3JlY2VpdmV4bG9nLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s
L3JlZi9wZ19yZWNlaXZleGxvZy5zZ21sCkBAIC0zMjQsMTcgKzMyNCwxMiBA
QCA8dGl0bGU+Tm90ZXM8L3RpdGxlPgogCiAgIDxwYXJhPgogICAgV2hlbiB1
c2luZyA8YXBwbGljYXRpb24+cGdfcmVjZWl2ZXhsb2c8L2FwcGxpY2F0aW9u
PiBpbnN0ZWFkIG9mCi0gICA8eHJlZiBsaW5rZW5kPSJndWMtYXJjaGl2ZS1j
b21tYW5kIj4sIHRoZSBzZXJ2ZXIgd2lsbCBjb250aW51ZSB0bwotICAgcmVj
eWNsZSB0cmFuc2FjdGlvbiBsb2cgZmlsZXMgZXZlbiBpZiB0aGUgYmFja3Vw
cyBhcmUgbm90IHByb3Blcmx5Ci0gICBhcmNoaXZlZCwgc2luY2UgdGhlcmUg
aXMgbm8gY29tbWFuZCB0aGF0IGZhaWxzLiBUaGlzIGNhbiBiZSB3b3JrZWQK
LSAgIGFyb3VuZCBieSBoYXZpbmcgYW4gPHhyZWYgbGlua2VuZD0iZ3VjLWFy
Y2hpdmUtY29tbWFuZCI+IHRoYXQgZmFpbHMKLSAgIHdoZW4gdGhlIGZpbGUg
aGFzIG5vdCBiZWVuIHByb3Blcmx5IGFyY2hpdmVkIHlldCwgZm9yIGV4YW1w
bGU6Ci08cHJvZ3JhbWxpc3Rpbmc+Ci1hcmNoaXZlX2NvbW1hbmQgPSAnc2xl
ZXAgNSAmYW1wOyZhbXA7IHRlc3QgLWYgL21udC9zZXJ2ZXIvYXJjaGl2ZWRp
ci8lZicKLTwvcHJvZ3JhbWxpc3Rpbmc+Ci0gICBUaGUgaW5pdGlhbCB0aW1l
b3V0IGlzIG5lY2Vzc2FyeSBiZWNhdXNlCi0gICA8YXBwbGljYXRpb24+cGdf
cmVjZWl2ZXhsb2c8L2FwcGxpY2F0aW9uPiB3b3JrcyB1c2luZyBhc3luY2hy
b25vdXMKLSAgIHJlcGxpY2F0aW9uIGFuZCBjYW4gdGhlcmVmb3JlIGJlIHNs
aWdodGx5IGJlaGluZCB0aGUgbWFzdGVyLgorICAgPHhyZWYgbGlua2VuZD0i
Z3VjLWFyY2hpdmUtY29tbWFuZCI+IGFzIHRoZSBtYWluIFdBTCBiYWNrdXAg
bWV0aG9kLCBpdCBpcworICAgc3Ryb25nbHkgcmVjb21tZW5kZWQgdG8gdXNl
IHJlcGxpY2F0aW9uIHNsb3RzLiAgT3RoZXJ3aXNlLCB0aGUgc2VydmVyIGlz
CisgICBmcmVlIHRvIHJlY3ljbGUgb3IgcmVtb3ZlIHRyYW5zYWN0aW9uIGxv
ZyBmaWxlcyBiZWZvcmUgdGhleSBhcmUgYmFja2VkIHVwLAorICAgYmVjYXVz
ZSBpdCBkb2VzIG5vdCBoYXZlIGFueSBpbmZvcm1hdGlvbiwgZWl0aGVyCisg
ICBmcm9tIDx4cmVmIGxpbmtlbmQ9Imd1Yy1hcmNoaXZlLWNvbW1hbmQiPiBv
ciB0aGUgcmVwbGljYXRpb24gc2xvdHMsIGFib3V0CisgICBob3cgZmFyIHRo
ZSBXQUwgc3RyZWFtIGhhcyBiZWVuIGFyY2hpdmVkLgogICA8L3BhcmE+CiAK
ICA8L3JlZnNlY3QxPgo=

--------------070504050403070009030104
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--------------070504050403070009030104--