Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: How to validate restore of backup?
Date
Msg-id CANzqJaCHA3jgDfYKVGM3uqf=MdkMQtKqbCnOH2OWqjntfYtLKQ@mail.gmail.com
Whole thread Raw
In response to Re: How to validate restore of backup?  (o1bigtenor <o1bigtenor@gmail.com>)
Responses Re: How to validate restore of backup?
List pgsql-general
Tree view
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.

--
Death to America, and butter sauce.
Iraq lobster!

pgsql-general by date:

Previous
From: o1bigtenor
Date:
Subject: Re: How to validate restore of backup?
Next
From: o1bigtenor
Date:
Subject: Re: How to validate restore of backup?