Re: upgrade from 13 to 16 - Mailing list pgsql-admin

From Ilya Kosmodemiansky
Subject Re: upgrade from 13 to 16
Date
Msg-id CAG95seVY8rHSnksNig5-81ZX5PyQ3MAagVV9x4=JJy-Bu62iSg@mail.gmail.com
Whole thread
In response to upgrade from 13 to 16  (listy <listy@localities.work>)
Responses Re: upgrade from 13 to 16
List pgsql-admin
Hi listy,

On Mon, Mar 2, 2026 at 1:43 PM 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 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@dataegret.com


pgsql-admin by date:

Previous
From: listy
Date:
Subject: upgrade from 13 to 16
Next
From: listy
Date:
Subject: Re: upgrade from 13 to 16