MIME-Version: 1.0
References: <20250705125207.31b4d475@pfortin.com>
In-Reply-To: <20250705125207.31b4d475@pfortin.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 5 Jul 2025 10:00:17 -0700
Message-ID: <CAKFQuwZCjr5DFnHXu=qCihw-aMeTprO2tB5e1KwHDQHcigdi2g@mail.gmail.com>
Subject: Re: pg_upgrade: can I use same binary for old & new?
To: Pierre Fortin <pf@pfortin.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a93a8a0639318d49"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZCjr5DFnHXu%3DqCihw-aMeTprO2tB5e1KwHDQHcigdi2g%40mail.gmail.com>
Precedence: bulk

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

On Sat, Jul 5, 2025 at 9:52=E2=80=AFAM Pierre Fortin <pf@pfortin.com> wrote=
:

> If new pg_upgrade is the only binary, will both -b and -B default to it?
> Maybe at minimum I may need to specify:
> $ pg_upgrade -b /usr/bin -d data15 -D data17 -k
>
>
 pgsql/pgsql-18/bin
> ./pg_ctl -D /var/pgsql/postgres-17 start
waiting for server to start....2025-07-05 16:58:56.559 UTC [293839] FATAL:
 database files are incompatible with server
2025-07-05 16:58:56.559 UTC [293839] DETAIL:  The data directory was
initialized by PostgreSQL version 17, which is not compatible with this
version 18beta1.
pg_ctl: control file appears to be corrupt


David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, Jul 5, 2025 at 9:52=E2=80=AFAM Pierre Fortin &lt;<=
a href=3D"mailto:pf@pfortin.com">pf@pfortin.com</a>&gt; wrote:</span></div>=
</div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex">If new pg_upgrade is the only binary, will bo=
th -b and -B default to it?<br>
Maybe at minimum I may need to specify:<br>
$ pg_upgrade -b /usr/bin -d data15 -D data17 -k<br><br></blockquote><div><b=
r></div><div>=C2=A0pgsql/pgsql-18/bin</div><span class=3D"gmail_default" st=
yle=3D"font-family:arial,helvetica,sans-serif">&gt;</span>=C2=A0./pg_ctl -D=
 /var/pgsql/postgres-17 start<br>waiting for server to start....2025-07-05 =
16:58:56.559 UTC [293839] FATAL: =C2=A0database files are incompatible with=
 server<br>2025-07-05 16:58:56.559 UTC [293839] DETAIL: =C2=A0The data dire=
ctory was initialized by PostgreSQL version 17, which is not compatible wit=
h this version 18beta1.<br>pg_ctl: control file appears to be corrupt</div>=
<div class=3D"gmail_quote gmail_quote_container"><br></div><div class=3D"gm=
ail_quote gmail_quote_container"><br></div><div class=3D"gmail_quote gmail_=
quote_container"><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">David J.</div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000a93a8a0639318d49--