MIME-Version: 1.0
References: <cb103623-8ee6-4ba5-a2c9-f32e3a4933fa@dunslane.net>
 <ZmcKMF61K4Ck51dK@nathan> <CABUevExoQ26jo+aQ9QZq+UMA1aD6gfpm9xBnh_t5e0DhaCeRYA@mail.gmail.com>
 <ZmcVqPOGjoccIh-i@nathan> <CABUevEyMEaaY37_eMW76F97TX2voxdtPNkm3FGqN9c3ZHy3GMg@mail.gmail.com>
 <740696.1718036463@sss.pgh.pa.us>
In-Reply-To: <740696.1718036463@sss.pgh.pa.us>
From: Magnus Hagander <magnus@hagander.net>
Date: Mon, 10 Jun 2024 21:36:37 +0200
Message-ID: <CABUevEwv4kQ5of9e+3mZ=Q9ZfkNtDbidPCLuDU_sm00d2Yf-rQ@mail.gmail.com>
Subject: Re: Non-text mode for pg_dumpall
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nathan Bossart <nathandbossart@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, 
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000645a4f061a8e45cc"
Archived-At: <https://www.postgresql.org/message-id/CABUevEwv4kQ5of9e%2B3mZ%3DQ9ZfkNtDbidPCLuDU_sm00d2Yf-rQ%40mail.gmail.com>
Precedence: bulk

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

On Mon, Jun 10, 2024 at 6:21=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Magnus Hagander <magnus@hagander.net> writes:
> > On Mon, Jun 10, 2024 at 5:03=E2=80=AFPM Nathan Bossart <nathandbossart@=
gmail.com
> >
> > wrote:
> >> Is there a particular advantage to that approach as opposed to just
> using
> >> "directory" mode for everything?
>
> > A gazillion files to deal with? Much easier to work with individual
> custom
> > files if you're moving databases around and things like that.
> > Much easier to monitor eg sizes/dates if you're using it for backups.
>
> You can always tar up the directory tree after-the-fact if you want
> one file.  Sure, that step's not parallelized, but I think we'd need
> some non-parallelized copying to create such a file anyway.
>

That would require double the disk space.

But you can also just run pg_dump manually on each database and a
pg_dumpall -g like people are doing today -- I thought this whole thing was
about making it more convenient :)

--=20
 Magnus Hagander
 Me: https://www.hagander.net/ <http://www.hagander.net/>
 Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun 10, 2024 at 6:21=E2=80=AFPM T=
om Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</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 rgb(204,204,204);=
padding-left:1ex">Magnus Hagander &lt;<a href=3D"mailto:magnus@hagander.net=
" target=3D"_blank">magnus@hagander.net</a>&gt; writes:<br>
&gt; On Mon, Jun 10, 2024 at 5:03=E2=80=AFPM Nathan Bossart &lt;<a href=3D"=
mailto:nathandbossart@gmail.com" target=3D"_blank">nathandbossart@gmail.com=
</a>&gt;<br>
&gt; wrote:<br>
&gt;&gt; Is there a particular advantage to that approach as opposed to jus=
t using<br>
&gt;&gt; &quot;directory&quot; mode for everything?<br>
<br>
&gt; A gazillion files to deal with? Much easier to work with individual cu=
stom<br>
&gt; files if you&#39;re moving databases around and things like that.<br>
&gt; Much easier to monitor eg sizes/dates if you&#39;re using it for backu=
ps.<br>
<br>
You can always tar up the directory tree after-the-fact if you want<br>
one file.=C2=A0 Sure, that step&#39;s not parallelized, but I think we&#39;=
d need<br>
some non-parallelized copying to create such a file anyway.<br></blockquote=
><div><br></div><div>That would require double the disk space.</div><div><b=
r></div><div>But you can also just run pg_dump manually on each database an=
d a pg_dumpall -g like people are doing today -- I thought this whole thing=
 was about making it more convenient :)</div><div>=C2=A0</div></div><span c=
lass=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gma=
il_signature"><div dir=3D"ltr"><div>=C2=A0Magnus Hagander<br>=C2=A0Me: <a h=
ref=3D"http://www.hagander.net/" target=3D"_blank">https://www.hagander.net=
/</a><br>=C2=A0Work: <a href=3D"http://www.redpill-linpro.com/" target=3D"_=
blank">https://www.redpill-linpro.com/</a></div></div></div></div>

--000000000000645a4f061a8e45cc--