Re: update to 16.2 - Mailing list pgsql-general

From Christophe Pettus
Subject Re: update to 16.2
Date
Msg-id B6D8F675-8BB7-4DD3-B325-C2C4F776C6D9@thebuild.com
Whole thread Raw
In response to update to 16.2  (Matthias Apitz <guru@unixarea.de>)
Responses Re: update to 16.2  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general

> On Mar 8, 2024, at 00:53, Matthias Apitz <guru@unixarea.de> wrote:
> It does not say definitely that for all other versions a dump/restore is
> required.

You cannot just replace the binaries to upgrade from an earlier major version to 16.X.  The release notes use "a
dump/restore(is/is not) required" to indicated whether you can just replace the binaries ("is not") and restart the
serveron the same database files. 

Dump/restore is not the only option for a major version upgrade.  You can use the pg_upgrade utility that is part of
thestandard distribution, or logical replication to a new server on the new version. 


pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: update to 16.2
Next
From: Daniel Gustafsson
Date:
Subject: Re: update to 16.2