Postgres Pro
Downloads
Home   >   mailing lists

Re: How to validate restore of backup? - Mailing list pgsql-general

From o1bigtenor
Subject Re: How to validate restore of backup?
Date
Msg-id CAPpdf5-_+dL1f9W2BaveRQhw0rX+eFfXBD4MfDJTQ6Yoe55sCQ@mail.gmail.com
Whole thread Raw
In response to Re: How to validate restore of backup?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: How to validate restore of backup?
List pgsql-general
Tree view


On Thu, Aug 22, 2024 at 8:03 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor <o1bigtenor@gmail.com> wrote:


On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
That's great on small databases.  Not so practical when they're big.

So - - - - what is the recommended procedure for 'large' databases?

(Might be useful to have a definition for what a large database is as well.) 

"Large" is when it takes too long to run TWO text mode pg_dump commands in addition to the pg_dump and pg_restore.


Hmmmmmmmmm - - - - I'd say that's about as neat a non-answer as I've ever seen. 

Can you try again?

(You forgot the first question - - - maybe you could try that one too - - - what is the recommended procedure
for 'large' databases?)

Regards

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: How to validate restore of backup?
Next
From: Greg Sabino Mullane
Date:
Subject: Re: How to validate restore of backup?