MIME-Version: 1.0
References: <20250705125207.31b4d475@pfortin.com> <b558441b-0bd8-4cfb-aa4c-64fdcb530531@aklaver.com>
In-Reply-To: <b558441b-0bd8-4cfb-aa4c-64fdcb530531@aklaver.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 5 Jul 2025 14:19:45 -0400
Message-ID: <CANzqJaCA_FA+e4kn5yqgSm=fc-cPrgFQocL12-45R-UUeEmwyQ@mail.gmail.com>
Subject: Re: pg_upgrade: can I use same binary for old & new?
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005c1901063932a8d6"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCA_FA%2Be4kn5yqgSm%3Dfc-cPrgFQocL12-45R-UUeEmwyQ%40mail.gmail.com>
Precedence: bulk

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

On Sat, Jul 5, 2025 at 2:11=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

> On 7/5/25 09:52, Pierre Fortin wrote:
> > Hi,
> >
> > [Hope this gets through after dumping DKIM-ignorant mail provider.]
> >
> > Wanting to upgrade from:
> > PostgreSQL 15.13 on x86_64-mageia-linux-gnu,
> > compiled by gcc (Mageia 15.1.0-1.mga10) 15.1.0, 64-bit
> > to:
> > PG 17.5
> >
> > Way back, I was able to use -k|--link option on pg_upgrade (PG13 to
> PG15);
> > but since then:
> >
> > - my DB has grown to over 8TB
>
> How did you measure above?
>
> > - even with ~70TB, I don't have enough contiguous disk space to
> >    dump/restore
>
> What was the pg_dump command?


For something that big, he must have been doing an uncompressed plain
format dump instead of a directory/custom format dump.  Maybe even added
--attribute-inserts too.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Jul 5, 2025 at 2:11=E2=80=AFPM Ad=
rian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@=
aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_conta=
iner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex">On 7/5/25 09:52, Pi=
erre Fortin wrote:<br>
&gt; Hi,<br>
&gt; <br>
&gt; [Hope this gets through after dumping DKIM-ignorant mail provider.]<br=
>
&gt; <br>
&gt; Wanting to upgrade from:<br>
&gt; PostgreSQL 15.13 on x86_64-mageia-linux-gnu,<br>
&gt; compiled by gcc (Mageia 15.1.0-1.mga10) 15.1.0, 64-bit<br>
&gt; to:<br>
&gt; PG 17.5<br>
&gt; <br>
&gt; Way back, I was able to use -k|--link option on pg_upgrade (PG13 to PG=
15);<br>
&gt; but since then:<br>
&gt; <br>
&gt; - my DB has grown to over 8TB<br>
<br>
How did you measure above?<br>
<br>
&gt; - even with ~70TB, I don&#39;t have enough contiguous disk space to<br=
>
&gt;=C2=A0 =C2=A0 dump/restore<br>
<br>
What was the pg_dump command?</blockquote><div><br></div><div>For something=
 that big, he must have been doing an uncompressed plain format dump instea=
d of a directory/custom format dump.=C2=A0 Maybe even added <span style=3D"=
background-color:rgb(248,249,250);color:rgb(0,0,0);font-family:monospace,mo=
nospace;font-size:14.4px">--attribute-inserts</span>=C2=A0too.</div><div><b=
r></div></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--0000000000005c1901063932a8d6--