Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

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.

  • PostgreSQL 18 moved data directory down one level to /var/lib/postgresql/18/docker
  • pgupgrade --link allows hard link within single mount, but blocked by volume mounted at PGDATA
  • Dump and restore method slower than pgupgrade --link, but compatible with data checksums

More from Monday 2 November →