Differences

This shows you the differences between two versions of the page.

--- checksum [2024/08/29 12:52] – created jbi
+++ checksum [2025/05/31 08:29] (current) – jbi
@@ Line 1: / Line 1: @@
 ====== enable checksum after creation (initdb) ======
-Ubuntu 24.04 / postgres v16 with primary and secondary:
+**Ubuntu 24.04 / postgres v16 with primary and secondary:**
+ * shutdown primary and secondary
-secondary: shut down the secondary
+ * and - on both clusters:
+<code>
+sudo -u postgres /usr/lib/postgresql/16/bin/pg_checksums -P -e -D $PGDATA
 </code>
-/usr/lib/postgresql/16/bin/pg_checksums -P -e -D /var/lib/postgresql/16/CLUSTER_NAME
+ * Start the primary and secondary
-</code>
+ * And check if checksum is enabled on both (on):
-primary: shut down the primary
+ <code>
+sudo -u postgres psql -c "show data_checksums"
-</code>
-/usr/lib/postgresql/16/bin/pg_checksums -P -e -D /var/lib/postgresql/16/CLUSTER_NAME
-</code>
-Start the primary
-Start the secondary
-Check if checksum is enabled on both:
-<code>
-show data_checksums;
 </code>