update to 16.2 - Mailing list pgsql-general

From Matthias Apitz
Subject update to 16.2
Date
Msg-id ZerSFS6iNNGPyo0W@pureos
Whole thread Raw
Responses Re: update to 16.2  (Christophe Pettus <xof@thebuild.com>)
Re: update to 16.2  (Daniel Gustafsson <daniel@yesql.se>)
Re: update to 16.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hello,

We plan to update our customers on SuSE Linux from 11.4, 13.1, 14.1 and
15.1 to 16.2. Do I understand the release notes correct that for this
the way is only dump/restore? The release notes say:

https://www.postgresql.org/docs/release/16.2/
...
A dump/restore is not required for those running 16.X.
...
It does not say definitely that for all other versions a dump/restore is
required.

We could even unload in the databases the ~400 tables to COPY format,
re-create the tables in a new 16.2 server and load the ~400 files (all this
relatively easy per scripts we created to migrate from Sybase and Oracle
to PostgreSQL). But I think, producing the dump with the old version,
setup new cluster and load the dump with the 16.2 sql command will work.

Any comments?

    matthias


-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

I am not at war with Russia.  Я не воюю с Россией.
Ich bin nicht im Krieg mit Russland.



pgsql-general by date:

Previous
From: sud
Date:
Subject: Question related to partitioning with pg_partman
Next
From: Christophe Pettus
Date:
Subject: Re: update to 16.2