Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z1RWU-0004JI-SN for pgsql-admin@arkaria.postgresql.org; Sun, 07 Jun 2015 03:45:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z1RWT-0005DV-3k for pgsql-admin@arkaria.postgresql.org; Sun, 07 Jun 2015 03:45:21 +0000 Received: from makus.postgresql.org ([174.143.35.229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z1RWS-0005DO-0Y for pgsql-admin@postgresql.org; Sun, 07 Jun 2015 03:45:20 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Z1RUH-0004wF-MP for pgsql-admin@postgresql.org; Sun, 07 Jun 2015 03:43:11 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id 6F62EE61554 for ; Sat, 6 Jun 2015 20:43:05 -0700 (PDT) Date: Sat, 6 Jun 2015 20:43:04 -0700 (MST) From: sinasaharkhiz To: pgsql-admin@postgresql.org Message-ID: <1433648584210-5852817.post@n5.nabble.com> In-Reply-To: References: <1433522860532-5852659.post@n5.nabble.com> <1433551664522-5852767.post@n5.nabble.com> Subject: Re: Decreasing the data loss after failover MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Yeah I just set the archive_timeout to 5 minutes. But I thought that would make postgresql to generate more wal files than before. Because the wal files would be switched before getting completely full. So that would make more 16MB wal files with less than 16MB data, and that will increase the size of my backup. But after I changed archive_timeout and restarted the barman backup, it has not increased. So I wonder if I'm thinking wrong about it or I have done something wrong. Do you have any idea about this? -- View this message in context: http://postgresql.nabble.com/Decreasing-the-data-loss-after-failover-tp5852659p5852817.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin