Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sh7G9-00D7XS-MU
	for pgsql-general@arkaria.postgresql.org; Thu, 22 Aug 2024 12:49:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sh7G7-002Opg-OH
	for pgsql-general@arkaria.postgresql.org; Thu, 22 Aug 2024 12:49:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <o1bigtenor@gmail.com>)
	id 1sh7G7-002OpP-Cx
	for pgsql-general@lists.postgresql.org; Thu, 22 Aug 2024 12:49:47 +0000
Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <o1bigtenor@gmail.com>)
	id 1sh7G0-000wyH-LX
	for pgsql-general@lists.postgresql.org; Thu, 22 Aug 2024 12:49:47 +0000
Received: by mail-lf1-x129.google.com with SMTP id 2adb3069b0e04-53349d3071eso991490e87.2
        for <pgsql-general@lists.postgresql.org>; Thu, 22 Aug 2024 05:49:41 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1724330980; x=1724935780; darn=lists.postgresql.org;
        h=cc:subject:message-id:date:from:in-reply-to:references:mime-version
         :from:to:cc:subject:date:message-id:reply-to;
        bh=r9h6CAfEpguPOcxcixmTT8kmtnNVUuVp7RcDV+1lslo=;
        b=VU3+lqmM5JZRRK0yU+LhMKmbX2UQuayGD5hNk5BfzV4XHVQ3BVF1CJfvWBp2qj75Cv
         wdxWNXkhoqD9eAI2hGLiQAE/L0Uth1xRKuZ1VPicpqhog+cyFHGSthAAL+mDhS6n9dW1
         dBElGIcJYHpDbVnvnuRw/QvaNevlt5fdIRQdVO1+ywGqr4rydH0kjgEp5Y/iJf+cGoGN
         kULppHIIVHn7Hi4E5uKjWxy7aIjyNL/ltI/Ev9iUmG/o0M7aZ0if/23uw0mnzqqyDsTJ
         MmK+S+VvANF6ALok4hRD6eiDYc8YUK9iM1Obcqc7nfmdZt0+E7BI93a1p0p0vho94AWy
         /GoQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1724330980; x=1724935780;
        h=cc:subject:message-id:date:from:in-reply-to:references:mime-version
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=r9h6CAfEpguPOcxcixmTT8kmtnNVUuVp7RcDV+1lslo=;
        b=W2VxDq4YoM78/t6WdKfTfB3OuQqi/sncxz80KCsa0hSfjn8GBPa6hVYKBJ7u0WUKq1
         YSbpobA5nVMx2zStNouZJ9khf0YFZZOBhCEo/aM6vni87RxZQu2TIAh21S5hzA6CUu55
         svXqkNOyPGgVA9/SJ/BYPEa/Ooc/zA0W2tJuApW5AmkD5X1SaseXEKl+7gFxZGVUpxkQ
         4iQUHNLyXB1umC+o6COPD6BwmlLQ4EK/AQCgW6o9wBzJmwQ2j9XJ5unX1ItHXjox4rri
         DuWNevARhV+ODxD6dDy9sEbxcWTuFARN9HAPSeOaIPuzvMzQxJAh9KejWyjb/b2DyY4j
         8H0Q==
X-Gm-Message-State: AOJu0Ywz609j7UD5PcWahGlprYvBi7t/KeqjC2rpXuyg6LFKQQ+V2sIl
	abVvvEEc1xr2QuTaaPOOylPpiesZoUzmYNuaIKEbGa6EljjChaIZ3EP8R2+alDY0B/DrwFyYMLi
	oo0S0DFMLqcT+pl6BI1iRje5JldfA34Yo
X-Google-Smtp-Source: AGHT+IEpX48TQq9xwze0owc0XVHKpPL+PbHoh6yMRsqV6+C1WzL2DR8U1i8jFd/h0TPXaRkcvMYU2X3UpsKoFXLvTmA=
X-Received: by 2002:a05:6512:b99:b0:530:ae22:a6f0 with SMTP id
 2adb3069b0e04-533485500cbmr3902345e87.5.1724330979851; Thu, 22 Aug 2024
 05:49:39 -0700 (PDT)
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>
In-Reply-To: <CANzqJaCxs4VwDZLw+JMdjjzvY8nC7MNvyH62GXNi2XTHAj3ghA@mail.gmail.com>
From: o1bigtenor <o1bigtenor@gmail.com>
Date: Thu, 22 Aug 2024 07:49:03 -0500
Message-ID: <CAPpdf5_mu_DJCbDY99Xa+BBJX0sMZo=yshohDT0TgUdjmMqRrg@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="0000000000008785ef0620451779"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAPpdf5_mu_DJCbDY99Xa%2BBBJX0sMZo%3DyshohDT0TgUdjmMqRrg%40mail.gmail.com>
Precedence: bulk

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

On Thu, Aug 22, 2024 at 6:24=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail.co=
m> 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.)

Regards

--0000000000008785ef0620451779
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 6:24=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>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 la=
rge database is as well.)=C2=A0 <br></div><div><br></div><div>Regards<br></=
div></div></div>

--0000000000008785ef0620451779--