| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "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-22 14:32:33 |
| Message-ID: | CANzqJaDuFPoUGF0sCa27EkMV9YEj=-_YO5rOED6Ti28OkUpnmQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 22, 2024 at 10:22 AM Greg Sabino Mullane <htamfids(at)gmail(dot)com>
wrote:
> On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor <o1bigtenor(at)gmail(dot)com> wrote:
>
>>
>>
>> On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)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.
>
Not useful when you're migrating not only between major versions but glibc
levels.
Use logical replication!! Maybe. It gets difficult with partitioned
tables that regularly have children added and dropped; mistakes can be
made. pg_dump/pg_restore is guaranteed to work.
--
Death to America, and butter sauce.
Iraq lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2024-08-22 14:38:07 | Re: How to validate restore of backup? |
| Previous Message | Greg Sabino Mullane | 2024-08-22 14:22:02 | Re: How to validate restore of backup? |