This is an old revision of the document!

enable checksum after creation (initdb)

Ubuntu 24.04 / postgres v16 with primary and secondary:

shutdown primary and secondary. On both:

sudo -u postgres /usr/lib/postgresql/16/bin/pg_checksums -P -e -D /var/lib/postgresql/16/CLUSTER_NAME

Start the primary and secondary

Check if checksum is enabled on both (on):

sudo -u postgres psql -c "show data_checksums"