Decreasing the data loss after failover

Поиск
Список
Период
Сортировка
От sinasaharkhiz
Тема Decreasing the data loss after failover
Дата
Msg-id 1433522860532-5852659.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Decreasing the data loss after failover  (Jorge Torralba <jorge.torralba@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: replication consistency checking
Следующее
От: Jorge Torralba
Дата:
Сообщение: Re: Decreasing the data loss after failover