Differences

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

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