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 -- In my defence, I have been left unsupervised.
