On 2023/04/18 17:24, Florian Obser wrote: > On 2023-04-18 15:47 +02, Landry Breuil <[email protected]> wrote: > > Le Tue, Apr 18, 2023 at 09:04:00AM +0100, Stuart Henderson a écrit : > >> On 2023/04/18 09:05, Landry Breuil wrote: > >> > What do postgresql users do when upgrading databases with extensions ? > >> > Use the manual dump/restore way ? > >> > >> That's what I did last time I needed it. I thought the pkg-readme > >> mentioned this but I just checked and I see it doesn't so at least we > >> shoukd add that. > > > > You mean a mention to users of extensions that the pg_upgrade path might > > not work in their case ? > > > >> The main tricky bit with that method is that you need to remember > >> to dump before updating the OS, because new kernels fairly often > >> won't run old binaries, there have been times I've had to mess around > >> with the ports tree to build old postgresql on the new release to > >> recover from that. > > > > I'm now used to dump all dbs prioir to sysupgrade :) > > You could also just get the dump out of your multiply redundant > backups. :P
Or failover to the secondary server :D
