Postgres Pro
Downloads
Home   >   mailing lists

Re: Time taken for 1TB postgres restore - RTO - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Time taken for 1TB postgres restore - RTO
Date
Msg-id CANP8+jLLpWHJV_8XgLJ4fzy15ShmBDmtUy1b2y=CueFCREfZcQ@mail.gmail.com
Whole thread Raw
In response to Time taken for 1TB postgres restore - RTO  (Raj kumar <rajkumar820999@gmail.com>)
Responses Re: Time taken for 1TB postgres restore - RTO  (Raj kumar <rajkumar820999@gmail.com>)
List pgsql-admin
Tree view
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 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.

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.

--
Simon Riggs                http://www.2ndQuadrant.com/
Mission Critical Databases

pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: Time taken for 1TB postgres restore - RTO
Next
From: Raj kumar
Date:
Subject: Re: Time taken for 1TB postgres restore - RTO