4 ms·

pg_upgrade has worked fine for years now, no need for manual dump/restore https://www.postgresql.org/docs/current/pgupgrade.html https://www.postgresql.org/doc

pg_upgrade has worked fine for years now, no need for manual dump/restore https://www.postgresql.org/docs/current/pgupgrade.html https://www.postgresql.org/docs/current/pgupgrade.html

Arch-TK 1y ago
You are right, but it's still a manual step I have to remind myself how to perform every time I upgrade. Thankfully the OpenBSD docs remind me, otherwise I wouldn't remember: https://www.openbsd.org/faq/upgrade77.html https://www.openbsd.org/faq/upgrade77.html https://github.com/openbsd/ports/blob/master/databases/postgresql/pkg/README-server https://github.com/openbsd/ports/blob/master/databases/postg...