Re: How to validate restore of backup?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Vince McMahon <sippingonesandzeros(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to validate restore of backup?
Date: 2024-08-23 00:15:07
Message-ID: 6ba6512d-2e5f-47c6-8fb8-5689df2ad3ed@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/22/24 14:31, Vince McMahon wrote:
> Hi, Adrian.
>
> The largest one is 8 GB after compression.
>
> I have a window of 8 hours to handle 30 GB total of backup at various sizes.

I assume by compression you mean using some form of pg_dump -Fc.

As to your timeline determining whether that can be met is going to
depend on a more detailed explanation on your part of what you expect
from the dump/restore process.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arbol One 2024-08-23 00:35:39 where is postres installed?
Previous Message Tom Lane 2024-08-22 22:42:15 Re: Is there a way to translate pg_amop.amopstrategy into a description?