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> <CANzqJaCHA3jgDfYKVGM3uqf=MdkMQtKqbCnOH2OWqjntfYtLKQ@mail.gmail.com>
In-Reply-To: <CANzqJaCHA3jgDfYKVGM3uqf=MdkMQtKqbCnOH2OWqjntfYtLKQ@mail.gmail.com>
From: o1bigtenor <o1bigtenor@gmail.com>
Date: Thu, 22 Aug 2024 08:58:32 -0500
Message-ID: <CAPpdf5-_+dL1f9W2BaveRQhw0rX+eFfXBD4MfDJTQ6Yoe55sCQ@mail.gmail.com>
Subject: Re: How to validate restore of backup?
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000001851c06204610e9"
Archived-At: <https://www.postgresql.org/message-id/CAPpdf5-_%2BdL1f9W2BaveRQhw0rX%2BeFfXBD4MfDJTQ6Yoe55sCQ%40mail.gmail.com>
Precedence: bulk

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

On Thu, Aug 22, 2024 at 8:03=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail.co=
m> 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?
>>
>> (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.
>
>
Hmmmmmmmmm - - - - I'd say that's about as neat a non-answer as I've ever
seen.

Can you try again?

(You forgot the first question - - - maybe you could try that one too - - -
what is the recommended procedure
for 'large' databases?)

Regards

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

<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 8:03=E2=80=AF=
AM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">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 rgb(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"gmai=
l_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;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">ronljohnson=
jr@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-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></div></blockquote><div=
>So - - - - what is the recommended procedure for &#39;large&#39; databases=
?</div><div><br></div><div>(Might be useful to have a definition for what a=
 large database is as well.)=C2=A0</div></div></div></blockquote><div><br><=
/div><div>&quot;Large&quot; is when it takes too long to run <b>TWO</b>=C2=
=A0text mode pg_dump commands <b>in addition to</b> the pg_dump and pg_rest=
ore.</div></div><br></div></blockquote><div><br></div><div>Hmmmmmmmmm - - -=
 - I&#39;d say that&#39;s about as neat a non-answer as I&#39;ve ever seen.=
=C2=A0</div><div><br></div><div>Can you try again?</div><div><br></div><div=
>(You forgot the first question - - - maybe you could try that one too - - =
- what is the recommended procedure <br></div><div>for &#39;large&#39; data=
bases?) <br></div><div><br></div><div>Regards<br></div></div></div>

--00000000000001851c06204610e9--