MIME-Version: 1.0
References: <7e69fa35-05c7-4cd9-9eba-90fd78b7cd18@localities.work>
In-Reply-To: <7e69fa35-05c7-4cd9-9eba-90fd78b7cd18@localities.work>
Reply-To: ik@dataegret.com
From: Ilya Kosmodemiansky <ik@dataegret.com>
Date: Mon, 2 Mar 2026 13:49:00 +0100
Message-ID: 
 <CAG95seVY8rHSnksNig5-81ZX5PyQ3MAagVV9x4=JJy-Bu62iSg@mail.gmail.com>
Subject: Re: upgrade from 13 to 16
To: listy <listy@localities.work>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fd9585064c0a0440"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG95seVY8rHSnksNig5-81ZX5PyQ3MAagVV9x4%3DJJy-Bu62iSg%40mail.gmail.com>
Precedence: bulk

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

Hi listy,

On Mon, Mar 2, 2026 at 1:43=E2=80=AFPM listy <listy@localities.work> wrote:

>
> Is upgrade from ver. 13 to 16 possible?
>
 it is. You need to use the latest pg_upgrade binary (from version 16 in
this case)


>
> -> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/
>
>
You must identify the directory where the old cluster binaries reside.
>

It tells you exactly what to do. pg_upgrade requires both the old and new
clusters, data dirs and binaries.  So you need to specify aloof -b, -B, -d
and -D


> Please use the -b command-line option or the PGBINOLD environment variabl=
e.
> Failure, exiting
>
> Or is a restoration from a backup the only way?
>
> many thanks, L.
>


--=20
Ilya Kosmodemiansky
CEO, Founder

Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
ik@dataegret.com

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi listy,</div><br><div class=3D"gmail_qu=
ote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Ma=
r 2, 2026 at 1:43=E2=80=AFPM listy &lt;<a href=3D"mailto:listy@localities.w=
ork">listy@localities.work</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><u></u>

 =20

   =20
 =20
  <div><font size=3D"2" face=3D"Courier 10 Pitch"><br>
      Is upgrade from ver. 13 to 16 possible?<br></font></div></blockquote>=
<div>=C2=A0it is. You need to use the latest pg_upgrade binary (from versio=
n 16 in this case)=C2=A0<br></div><div>=C2=A0</div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div><font size=3D"2" face=3D"Courier 10 Pitch">
      <br>
      -&gt; $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/<br>
      </font>=C2=A0</div></blockquote><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div><font size=3D"2" face=3D"Courier 10 Pitch">
      You must identify the directory where the old cluster binaries
      reside.<br></font></div></blockquote><div><br></div><div>It tells you=
 exactly what to do. pg_upgrade requires both the old and new clusters, dat=
a dirs and binaries.=C2=A0=C2=A0So you need to specify aloof=C2=A0-b, -B, -=
d and -D</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div><font size=3D"2" face=3D"Courier 10 Pitch">
      Please use the -b command-line option or the PGBINOLD environment
      variable.<br>
      Failure, exiting<br>
      <br>
      Or is a restoration from a backup the only way?<br>
      <br>
      many thanks, L.</font>
  </div>

</blockquote></div><div><br clear=3D"all"></div><br><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Ilya Kosmodemiansky</div><div>CEO, Founder</div><br>Dat=
a Egret GmbH<br>Your remote PostgreSQL DBA team<br>T.: +49 6821 919 3297<br=
><a href=3D"mailto:ik@dataegret.com" target=3D"_blank">ik@dataegret.com</a>=
<br><br><br></div></div></div>

--000000000000fd9585064c0a0440--