Differences

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

--- checksum [2024/08/29 14:51] – 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
-  -
-  -   * and:
-  - <code>
+ * and - on both clusters:
-  - sudo -u postgres /usr/lib/postgresql/16/bin/pg_checksums -P -e -D PGDATA
-  - </code>
+<code>
-  -
+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):
-  -  - And check if checksum is enabled on both (on):
+ <code>
-  -
+sudo -u postgres psql -c "show data_checksums"
-  - <code>
+</code>
-  - sudo -u postgres psql -c "show data_checksums"
-  - </code>