Category: postgresql
- Convert PostgreSQL cluster to use page checksums ()
When upgrading PostgreSQL cluster from one major version to another you cannot use pg_upgrade tool to upgrade/convert cluster with page checksums disabled to a cluster with page checksums enabled. Instead you have to do dump and restore. On Debian/Ubuntu based systems this is made easier using the pg_createcluster / pg_dropcluster commands. Here I’m converting a […]