MIME-Version: 1.0
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> <CAKAnmmJVi=9HTtYw4L5hvW0oVQhxfo_hH=WK-qtgO+TnnNwtHw@mail.gmail.com>
In-Reply-To: <CAKAnmmJVi=9HTtYw4L5hvW0oVQhxfo_hH=WK-qtgO+TnnNwtHw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 22 Aug 2024 10:32:33 -0400
Message-ID: <CANzqJaDuFPoUGF0sCa27EkMV9YEj=-_YO5rOED6Ti28OkUpnmQ@mail.gmail.com>
Subject: Re: How to validate restore of backup?
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002de869062046882d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDuFPoUGF0sCa27EkMV9YEj%3D-_YO5rOED6Ti28OkUpnmQ%40mail.gmail.com>
Precedence: bulk

--0000000000002de869062046882d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Aug 22, 2024 at 10:22=E2=80=AFAM Greg Sabino Mullane <htamfids@gmai=
l.com>
wrote:

> On Thu, Aug 22, 2024 at 8:49=E2=80=AFAM o1bigtenor <o1bigtenor@gmail.com>=
 wrote:
>
>>
>>
>> On Thu, Aug 22, 2024 at 6:24=E2=80=AFAM 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.
>

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.

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

--0000000000002de869062046882d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Aug 22, 2024 at 10:22=E2=80=AFAM =
Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmai=
l.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Thu, =
Aug 22, 2024 at 8:49=E2=80=AFAM o1bigtenor &lt;<a href=3D"mailto:o1bigtenor=
@gmail.com" target=3D"_blank">o1bigtenor@gmail.com</a>&gt; wrote:<br></div>=
<div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Aug 22, 2024 at 6:24=E2=80=
=AFAM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"=
_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>That&#39;s great on =
small databases.=C2=A0 Not so practical when they&#39;re big.</div><br></di=
v></blockquote><div>So - - - - what is the recommended procedure for &#39;l=
arge&#39; databases?</div></div></div></blockquote><div><br></div><div>Use =
a real backup system like pgBackRest. Stop using pg_dump.</div></div></div>=
</blockquote><div>=C2=A0</div><div>Not useful when you&#39;re migrating not=
 only between major versions but glibc levels.</div><div><br></div><div>Use=
 logical replication!!=C2=A0 Maybe.=C2=A0 It gets difficult with partitione=
d tables that regularly have children added and dropped; mistakes can be ma=
de.=C2=A0 pg_dump/pg_restore is guaranteed to work.</div><div><br></div></d=
iv><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cl=
ass=3D"gmail_signature"><div dir=3D"ltr">Death to America, and butter sauce=
.<div>Iraq lobster!</div></div></div></div>

--0000000000002de869062046882d--