MIME-Version: 1.0
References: <CANzqJaAHOSNiOhe4D2hOBB46=puWQOZb=s=VQdNmUSOtOmRG5A@mail.gmail.com>
 <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com> <CANzqJaCMR-5eLMYy0ukywWeKpwySCAMQRrgKmW7A2CZ-mr9+0Q@mail.gmail.com>
 <7005ac8c-2f83-4122-9172-04bca268f987@aklaver.com> <CANzqJaBiUpeFExzS-wi8KzmZcxEEmi1FUVkoyL5=8FEx13S5dg@mail.gmail.com>
 <f3d35e91-9b80-4985-a1ca-fa0a5d8639d2@aklaver.com> <CAHAc2jcACDXv8=5EVO0YVVjANP=oj_=eeYeLXiG3LQC+kU0ewA@mail.gmail.com>
 <4b28e899-d802-43ce-b20b-655a9077f08f@gmail.com> <CANzqJaB86-8qozgb5Fmd48PJa4CrVo3o8BFGAiG0w6ynJfJJpA@mail.gmail.com>
In-Reply-To: <CANzqJaB86-8qozgb5Fmd48PJa4CrVo3o8BFGAiG0w6ynJfJJpA@mail.gmail.com>
From: Gavin Roy <gavinr@aweber.com>
Date: Tue, 4 Jun 2024 15:47:22 -0400
Message-ID: <CAFVAjJH3bA-rZNEyjDctD0TOZMjcyVqA7Ac_-xkBDaM8UUPFkA@mail.gmail.com>
Subject: Re: Purpose of pg_dump tar archive format?
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000929424061a15b8fd"
Archived-At: <https://www.postgresql.org/message-id/CAFVAjJH3bA-rZNEyjDctD0TOZMjcyVqA7Ac_-xkBDaM8UUPFkA%40mail.gmail.com>
Precedence: bulk

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

On Tue, Jun 4, 2024 at 3:15=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com=
> wrote:

>
> But why tar instead of custom? That was part of my original question.
>

I've found it pretty useful for programmatically accessing data in a dump
for large databases outside of the normal pg_dump/pg_restore workflow. You
don't have to seek through one large binary file to get to the data section
to get at the data.

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

<div dir=3D"ltr"><div dir=3D"ltr"></div><br><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Tue, Jun 4, 2024 at 3:15=E2=80=AFPM Ro=
n Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmai=
l.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin: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><div class=3D"gmail_quote"=
><div>But why tar instead of custom? That was part of my original question.=
</div></div></div></blockquote></div><div><br></div>I&#39;ve found it prett=
y useful for programmatically accessing data in a dump for large databases =
outside of the normal pg_dump/pg_restore workflow. You don&#39;t have to se=
ek through one large binary file to get to the data section to get at the d=
ata.<br></div>

--000000000000929424061a15b8fd--