From: sinasaharkhiz <sinas1991@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Decreasing the data loss after failover
Date: Fri, 5 Jun 2015 09:47:40 -0700 (MST)
Message-ID: <1433522860532-5852659.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sinas1991@gmail.com
Subject: Re: Decreasing the data loss after failover
In-Reply-To: <1433522860532-5852659.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox