MIME-Version: 1.0
References: 
 <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com>
 <7b149653-4992-9285-d9af-53929497f4e8@jakobs.com>
 <CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@mail.gmail.com>
 <1170092.1723530800@sss.pgh.pa.us>
 <CAB5fag71Y5bUiO1X+FGUH6o23Qa0PZOQBLVQW3g3bUvPtxkO4Q@mail.gmail.com>
In-Reply-To: 
 <CAB5fag71Y5bUiO1X+FGUH6o23Qa0PZOQBLVQW3g3bUvPtxkO4Q@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 13 Aug 2024 08:04:37 -0400
Message-ID: 
 <CANzqJaD7E6WR_fytkTcjHnU9nX4ktHR7WswbRUDZQdiPB+9Sqw@mail.gmail.com>
Subject: Re: pg_dump
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008ab602061f8f6ac5"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaD7E6WR_fytkTcjHnU9nX4ktHR7WswbRUDZQdiPB%2B9Sqw%40mail.gmail.com>
Precedence: bulk

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

"Free your mind, and *pg_dump* will follow."  Maybe *En Vogue*, but
probably not.

On Tue, Aug 13, 2024 at 2:43=E2=80=AFAM Wasim Devale <wasimd60@gmail.com> w=
rote:

> Then what might be the solution for it if I am only concerned about using
> pg_dump
>
> On Tue, 13 Aug, 2024, 12:03=E2=80=AFpm Tom Lane, <tgl@sss.pgh.pa.us> wrot=
e:
>
>> Wasim Devale <wasimd60@gmail.com> writes:
>> > I did one thing, we can exclude the toast table in the pg_dump command
>> that
>> > has the BLOBS data for a particular table.
>> > --exclude-table-data=3Dpg_toast.pg_toast_10176226
>>
>> Utterly pointless.  pg_dump does not dump toast tables as such;
>> it's only concerned with their parent "regular" tables.  It will
>> fetch data from the regular tables, and it's not concerned with
>> the server-side implementation detail that some of that data
>> might be coming out of a toast table.
>>
>>                         regards, tom lane
>>
>

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

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

<div dir=3D"ltr"><div>&quot;Free your mind, and <i>pg_dump</i> will follow.=
&quot;=C2=A0 Maybe=C2=A0<i>En Vogue</i>, but probably not.</div><br><div cl=
ass=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Aug 13, 2=
024 at 2:43=E2=80=AFAM Wasim Devale &lt;<a href=3D"mailto:wasimd60@gmail.co=
m">wasimd60@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><p dir=3D"ltr">Then what might be the solution for it =
if I am only concerned about using pg_dump</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, 13 Aug, 2024, 12:03=E2=80=AFpm Tom Lane, &lt;<a href=3D"mailto:tgl@sss.pg=
h.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex">Wasim Devale &lt;<a href=3D"mai=
lto:wasimd60@gmail.com" rel=3D"noreferrer" target=3D"_blank">wasimd60@gmail=
.com</a>&gt; writes:<br>
&gt; I did one thing, we can exclude the toast table in the pg_dump command=
 that<br>
&gt; has the BLOBS data for a particular table.<br>
&gt; --exclude-table-data=3Dpg_toast.pg_toast_10176226<br>
<br>
Utterly pointless.=C2=A0 pg_dump does not dump toast tables as such;<br>
it&#39;s only concerned with their parent &quot;regular&quot; tables.=C2=A0=
 It will<br>
fetch data from the regular tables, and it&#39;s not concerned with<br>
the server-side implementation detail that some of that data<br>
might be coming out of a toast table.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Death to America, and butter sauce.<div>Iraq lobster!</div><=
/div></div></div>

--0000000000008ab602061f8f6ac5--