How to upgrade Postgres in Docker to 18, and be ready for 19: dump and restore or pg_upgrade --link

I moved a Postgres database on Dokploy from 16 to 18 with pg_upgrade. It went fine, with the database down for under a minute, but it stopped twice on the way. First, pg_upgrade stopped at its checks: old cluster does not use data checksums but the new one does. Then 18 started, and my app couldn't connect. Neither stop was bad luck. Both follow... Weiterlesen: How to upgrade Postgres in Docker to 18, and be ready for 19: dump an…