Re: Time taken for 1TB postgres restore - RTO

[Simon Riggs <simon@xxxxxxxxxxxxxxx>]

On Fri, 17 Jul 2020 at 10:44, Raj kumar <rajkumar820999@xxxxxxxxx> 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