Re: Time taken for 1TB postgres restore - RTO

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(at)2ndquadrant(dot)com> wrote:

> On Fri, 17 Jul 2020 at 10:44, Raj kumar <rajkumar820999(at)gmail(dot)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/
> <http://www.2ndquadrant.com/>
> Mission Critical Databases
>