Request a Demo
Home   >   mailing lists

Re: pg_upgrade: can I use same binary for old & new? - Mailing list pgsql-general

From David G. Johnston
Subject Re: pg_upgrade: can I use same binary for old & new?
Date
Msg-id CAKFQuwZCjr5DFnHXu=qCihw-aMeTprO2tB5e1KwHDQHcigdi2g@mail.gmail.com
Whole thread Raw
In response to pg_upgrade: can I use same binary for old & new?  (Pierre Fortin <pf@pfortin.com>)
List pgsql-general
Tree view
On Sat, Jul 5, 2025 at 9:52 AM 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.

pgsql-general by date:

Previous
From: Pierre Fortin
Date:
Subject: pg_upgrade: can I use same binary for old & new?
Next
From: Tom Lane
Date:
Subject: Re: pg_upgrade: can I use same binary for old & new?