postgres.dk

User Tools

Site Tools

Trace:
checksum

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
checksum [2024/08/29 14:41] – jbichecksum [2025/05/31 08:29] (current) – jbi
Line 3: Line 3:
 **Ubuntu 24.04 / postgres v16 with primary and secondary:** **Ubuntu 24.04 / postgres v16 with primary and secondary:**
  
 + * shutdown primary and secondary
  
-shutdown primary and secondary. On both:+ * and - on both clusters:
  
 <code> <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> </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 (on): +
- +
-<code>+
 sudo -u postgres psql -c "show data_checksums" sudo -u postgres psql -c "show data_checksums"
 </code> </code>
checksum.1724935312.txt.gz · Last modified: 2024/08/29 14:41 by jbi