Differences

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

--- checksum [2024/08/29 14:40] – 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
-shutdown primary and secondary. On both:
+ * and - on both clusters:
 <code>
-sudo -u postgres /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
-Start the primary and secondary
+ * And check if checksum is enabled on both (on):
+ <code>
-Check if checksum is enabled on both:
+sudo -u postgres psql -c "show data_checksums"
-<code>
-show data_checksums;
 </code>