Re: Decreasing the data loss after failover

From: sinasaharkhiz <sinas1991(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Decreasing the data loss after failover
Date: 2015-06-07 03:43:04
Message-ID: 1433648584210-5852817.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2015-06-07 04:23:37 Re: Decreasing the data loss after failover
Previous Message Scott Ribe 2015-06-06 13:36:04 Re: Decreasing the data loss after failover