Backups + streaming replication + WAL-E

From: Maks Materkov <materkov(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Backups + streaming replication + WAL-E
Date: 2016-02-05 09:49:00
Message-ID: CABVsJ4ENhkhbYTqzbXmYpCakyw2ZYC3eOydPuXtyK6kK9dzz8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

In our company we user Postgres v 9.4, with streaming replication (master +
one replica).
We use WAL-E for backups (WAL files continuously archiving to S3), and use
wal-e backup-push every night.
Unfortunately, I see performance degradation while backup-push running, so
I use "--cluster-read-rate-limit" option.
For now, backup starting at 05:00 and ends at 12:00 (7 hours). And this
time getting bigger and bigger every day. I am not satisfied with this
solution.
We have one replica node. Is there any options to use replica as a source
for backups? Or some other scenarios?
Also, our app running in OpenStack cloud and we can easily do snapshots for
our disks. Maybe we should use this feature to solve very long backup time?

Thank you!

--
Maks

Browse pgsql-admin by date

  From Date Subject
Next Message rajan 2016-02-05 17:24:10 Monitoring Active Connections
Previous Message Thomas SIMON 2016-02-04 15:38:21 Re: Postgres 9.5 pg_prewarm