Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XgHMP-0002Tp-4T for pgsql-docs@arkaria.postgresql.org; Mon, 20 Oct 2014 18:07:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XgHMO-0007we-L5 for pgsql-docs@arkaria.postgresql.org; Mon, 20 Oct 2014 18:07:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XgHMO-0007wY-1S for pgsql-docs@postgresql.org; Mon, 20 Oct 2014 18:07:12 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XgHMK-0004NK-LT for pgsql-docs@postgresql.org; Mon, 20 Oct 2014 18:07:10 +0000 Received: from auth2-smtp.messagingengine.com ([66.111.4.228]) by mail.gmx.com (mrgmx001) with ESMTPSA (Nemesis) id 0LzskF-1YBTAo444B-0151RL for ; Mon, 20 Oct 2014 20:07:06 +0200 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by gateway2.nyi.internal (Postfix) with ESMTP id 71BE820E23 for ; Mon, 20 Oct 2014 14:07:04 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute6.internal (MEProxy); Mon, 20 Oct 2014 14:07:04 -0400 X-Sasl-enc: SfAXyAZY79xwAitYmUP37I6MfmbdpwUSnHgchUCCYFyd 1413828423 Received: from jesse.mybdev.com (unknown [204.145.120.11]) by mail.messagingengine.com (Postfix) with ESMTPA id DDC99C00008 for ; Mon, 20 Oct 2014 14:07:03 -0400 (EDT) Message-ID: <54454F47.50407@gmx.net> Date: Mon, 20 Oct 2014 14:07:03 -0400 From: Peter Eisentraut 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 Subject: obsolete pg_receivexlog note? Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:PlyPuJE0HBPLuPPi8BECe/ln/OfBuiv88bdET2dUPUEOC35YKqA 2gxAXUCyhlcDVEGOnlRzmxyWkbr1H2/GGxEv5ipx1U3z5wi9Fl6KFHQj/S124sEB4QVlZij bJuCYv3gHlkasHBHqjkb9Pd5zGrL9dKfp0b+QQhpgRVVIxKz4XAFcY+3OUGeX2vAVAwt52F FfziaBOWaWMWwtLNzETTQ== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -3.6 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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