Decreasing the data loss after failover - Mailing list pgsql-admin

From sinasaharkhiz
Subject Decreasing the data loss after failover
Date
Msg-id 1433522860532-5852659.post@n5.nabble.com
Whole thread Raw
Responses Re: Decreasing the data loss after failover  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Hi,
I use barman to backup the database of a production server of the company I
work in. Last month a hard disk failed and I had to recover the backup from
my barman server. But we've lost near 15 minutes of transactions, and since
this server is responsible for the bank payments 15 minutes of lost
transactions is too much.
I want to know what was the problem here and how can I fix it to prevent
this data loss next time? I think the wal files that postgresql were writing
on took more than 15 minutes at the time to finish.




--
View this message in context: http://postgresql.nabble.com/Decreasing-the-data-loss-after-failover-tp5852659.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: replication consistency checking
Next
From: Jorge Torralba
Date:
Subject: Re: Decreasing the data loss after failover