Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Sabino Mullane
Subject Re: How to validate restore of backup?
Date
Msg-id CAKAnmmJVi=9HTtYw4L5hvW0oVQhxfo_hH=WK-qtgO+TnnNwtHw@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?

Use a real backup system like pgBackRest. Stop using pg_dump.

Cheers,
Greg

pgsql-general by date:

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