Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iCMxa-0002QD-Ta for pgsql-general@arkaria.postgresql.org; Mon, 23 Sep 2019 11:56:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iCMxZ-0007gp-JB for pgsql-general@arkaria.postgresql.org; Mon, 23 Sep 2019 11:56:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iCMxZ-0007dH-7y for pgsql-general@lists.postgresql.org; Mon, 23 Sep 2019 11:56:53 +0000 Received: from mail.i-mark.de ([188.138.104.222]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iCMxX-0002QB-1y for pgsql-general@lists.postgresql.org; Mon, 23 Sep 2019 11:56:52 +0000 Received: from [192.168.178.20] (unknown [185.38.49.17]) by mail.i-mark.de (Postfix) with ESMTPSA id BE1481583A2D; Mon, 23 Sep 2019 13:56:45 +0200 (CEST) Authentication-Results: loft7616.startdedicated.de; spf=pass (sender IP is 185.38.49.17) smtp.mailfrom=andreas@a-kretschmer.de smtp.helo=[192.168.178.20] Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated) Subject: Re: pg_receivexlog or archive_command To: Luca Ferrari Cc: pgsql-general References: <57a86418-1841-89e0-d53b-dad445972169@a-kretschmer.de> From: Andreas Kretschmer Message-ID: Date: Mon, 23 Sep 2019 13:56:47 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Am 23.09.19 um 13:44 schrieb Luca Ferrari: > On Mon, Sep 23, 2019 at 10:55 AM Andreas Kretschmer > wrote: >> you can use both of them, and you should consider "Barman". > If I remember well Barman uses pg_receivexlog when streaming, and > archive_command when doing a "normal" backup. Barman < version 2 can only archive_command, version 2 and higher can both. > Also pgbackrest is another good tool for backup. > The idea here should be not reinventing the wheel. ack. Regards, Andreas > -- > 2ndQuadrant - The PostgreSQL Support Company. > www.2ndQuadrant.com