update to 16.2

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: update to 16.2
Date: 2024-03-08 08:53:41
Message-ID: ZerSFS6iNNGPyo0W@pureos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)unixarea(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-03-08 08:56:16 Re: update to 16.2
Previous Message sud 2024-03-08 08:23:00 Question related to partitioning with pg_partman