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
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 |