MIME-Version: 1.0
References: <CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r+XR2dug@mail.gmail.com>
 <a5d51855-e4f3-478c-a643-1fd2eb4a06da@vondra.me>
In-Reply-To: <a5d51855-e4f3-478c-a643-1fd2eb4a06da@vondra.me>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 16 Oct 2024 16:00:30 -0400
Message-ID: <CANzqJaA_bNat1U3Ku4PARtDw99zvYaA-ERTEdK7TKTaJkDsJtA@mail.gmail.com>
Subject: Re: Backup
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000042f96306249d865d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaA_bNat1U3Ku4PARtDw99zvYaA-ERTEdK7TKTaJkDsJtA%40mail.gmail.com>
Precedence: bulk

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

On Wed, Oct 16, 2024 at 3:52=E2=80=AFPM Tomas Vondra <tomas@vondra.me> wrot=
e:
[snip]

> You didn't specify the Postgres version - that matters, because older
> pg_dump versions (before PG 16) do not support compression. Since PG 16
> you can use either -Fc or -Fd (instead of the tar format), and it'll
> compress the output using gzip.
>

Not true.  pg_dump has had built-in gzipping of directory format backups
since at least 9.6.  Probably earlier.
--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Oct 16, 2024 at 3:52=E2=80=AFPM T=
omas Vondra &lt;<a href=3D"mailto:tomas@vondra.me">tomas@vondra.me</a>&gt; =
wrote:<br></div><div class=3D"gmail_quote"><div>[snip]=C2=A0</div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex">You didn&#39;t specify the Postgre=
s version - that matters, because older<br>
pg_dump versions (before PG 16) do not support compression. Since PG 16<br>
you can use either -Fc or -Fd (instead of the tar format), and it&#39;ll<br=
>
compress the output using gzip.<br>
</blockquote></div><br clear=3D"all"><div>Not true.=C2=A0 pg_dump has had b=
uilt-in gzipping of directory format backups since at least 9.6.=C2=A0 Prob=
ably earlier.</div><span class=3D"gmail_signature_prefix">-- </span><br><di=
v dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redac=
ted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><=
div><div>&lt;Redacted&gt; crustacean!</div></div></div></div></div></div>

--00000000000042f96306249d865d--