Decreasing the data loss after failover

From: sinasaharkhiz <sinas1991(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Decreasing the data loss after failover
Date: 2015-06-05 16:47:40
Message-ID: 1433522860532-5852659.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2015-06-05 21:22:54 Re: Decreasing the data loss after failover
Previous Message Scott Ribe 2015-06-05 14:56:54 Re: replication consistency checking