Re: update to 16.2

2024-03-08 Thread Adrian Klaver
On 3/8/24 00:53, Matthias Apitz wrote: 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/ ... . .

Re: update to 16.2

2024-03-08 Thread Greg Sabino Mullane
On Fri, Mar 8, 2024 at 5:01 AM Matthias Apitz wrote: > The other option (pg_upgrade) we never used. > You really should give this a shot. Much easier, and orders of magnitude faster with the --link option. It should work fine even with a custom-compiled postgres (really, as long as pg_dump can s

Re: update to 16.2

2024-03-08 Thread Ron Johnson
On Fri, Mar 8, 2024 at 5:01 AM Matthias Apitz wrote: > El día viernes, marzo 08, 2024 a las 12:56:16 -0800, Christophe Pettus > escribió: > > > > > > > > On Mar 8, 2024, at 00:53, Matthias Apitz wrote: > > > It does not say definitely that for all other versions a dump/restore > is > > > require

Re: update to 16.2

2024-03-08 Thread Matthias Apitz
El día viernes, marzo 08, 2024 a las 12:56:16 -0800, Christophe Pettus escribió: > > > > On Mar 8, 2024, at 00:53, Matthias Apitz 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 earlie

Re: update to 16.2

2024-03-08 Thread Daniel Gustafsson
> On 8 Mar 2024, at 09:53, Matthias Apitz wrote: > It does not say definitely that for all other versions a dump/restore is > required. I recommend reading https://www.postgresql.org/docs/16/upgrading.html before attempting anything. Minor version upgrades and major version upgrades are very di

Re: update to 16.2

2024-03-08 Thread Christophe Pettus
> On Mar 8, 2024, at 00:53, Matthias Apitz 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 indi

update to 16.2

2024-03-08 Thread Matthias Apitz
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 ru