Search Postgresql Archives

Re: How to validate restore of backup?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to validate restore of backup?
From: Greg Sabino Mullane <htamfids@xxxxxxxxx>
Date: Thu, 22 Aug 2024 10:22:02 -0400
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAPpdf5_mu_DJCbDY99Xa+BBJX0sMZo=yshohDT0TgUdjmMqRrg@mail.gmail.com>
References: <CAKS+vVZSg=LDpFThxZQyemYE470Hbb15W-YZDHv=-fEZjML2QA@mail.gmail.com> <CAPnRvGsmb57R7cD3KFjN6p=YrxXen-E_Xbs9QKHx7REKQfz--g@mail.gmail.com> <CANzqJaCxs4VwDZLw+JMdjjzvY8nC7MNvyH62GXNi2XTHAj3ghA@mail.gmail.com> <CAPpdf5_mu_DJCbDY99Xa+BBJX0sMZo=yshohDT0TgUdjmMqRrg@mail.gmail.com>

On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor <o1bigtenor@xxxxxxxxx> wrote:

On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to validate restore of backup?
  - From: Ron Johnson

References:
- How to validate restore of backup?
  - From: Vince McMahon
- Re: How to validate restore of backup?
  - From: Muhammad Usman Khan
- Re: How to validate restore of backup?
  - From: Ron Johnson
- Re: How to validate restore of backup?
  - From: o1bigtenor

Prev by Date: Re: How to validate restore of backup?
Next by Date: Re: How to validate restore of backup?
Previous by thread: Re: How to validate restore of backup?
Next by thread: Re: How to validate restore of backup?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]