Re: upgrade from 13 to 16

Hi listy,

On Mon, Mar 2, 2026 at 1:43 PM listy <listy(at)localities(dot)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 variable.
> Failure, exiting
>
> Or is a restoration from a backup the only way?
>
> many thanks, L.
>

--
Ilya Kosmodemiansky
CEO, Founder

Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
ik(at)dataegret(dot)com