Обсуждение: Time taken for 1TB postgres restore - RTO
Hi experts,
I'm looking for the information on how much time does it take to restore 1TB Postgres database during DR in cloud solutions like
1) GCP
2) Azure-Single server & Citus
3) AWS Aurora & RDS
If anybody has the answer for any of this, please respond. Its a good help for me.
Thanks,
Raj Kumar
On Fri, 17 Jul 2020 at 10:44, Raj kumar <rajkumar820999@gmail.com> wrote:
Hi experts,I'm looking for the information on how much time does it take to restore 1TB Postgres database during DR in cloud solutions like1) GCP2) Azure-Single server & Citus3) AWS Aurora & RDSIf anybody has the answer for any of this, please respond. Its a good help for me.
The answer depends heavily on whether your DR planning includes a hot standby server (near zero RTO) or just a cold backup (O(N) RTO) to recover from.
If you're running on a managed service you should ask the service provider about this.
Hi Simon,
Thanks for your helpful response 🙂
I'm looking for the Recovery time for Cold Backup Restore without a DR Node setup.
eg. Complete Master database cluster rebuild after a disaster.
Thanks,
Raj Kumar.
On Fri, 17 Jul 2020, 15:37 Simon Riggs, <simon@2ndquadrant.com> wrote:
On Fri, 17 Jul 2020 at 10:44, Raj kumar <rajkumar820999@gmail.com> wrote:Hi experts,I'm looking for the information on how much time does it take to restore 1TB Postgres database during DR in cloud solutions like1) GCP2) Azure-Single server & Citus3) AWS Aurora & RDSIf anybody has the answer for any of this, please respond. Its a good help for me.The answer depends heavily on whether your DR planning includes a hot standby server (near zero RTO) or just a cold backup (O(N) RTO) to recover from.If you're running on a managed service you should ask the service provider about this.--