4 ms·
As someone who operates both I much prefer to run pg_upgrade every few years rather than dealing with mysqldump, replication issues and babysitting Orchestrator
by mxey 2y ago
As someone who operates both I much prefer to run pg_upgrade every few years rather than dealing with mysqldump, replication issues and babysitting Orchestrator.
- literalAardvark 2y agojust as long as you don't forget to reindex after
- mxey 2y ago> All failure, rebuild, and reindex cases will be reported by pg_upgrade if they affect your installation; post-upgrade scripts to rebuild tables and indexes will be generated automatically.
- literalAardvark 2y agoNot true. Those scripts only cover problems caused by PostgreSQL itself, not, for example, a change in collations that will silently break your indexes, such as the one in Debian 12.
- djbusby 2y agoIt's a step of your script or runbook. Right?
- literalAardvark 2y agoIt is, but it also takes a very long time during which production data integrity can be severely affected.