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:48] – 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 + * and - on both clusters:
- +
-- and:+
  
 <code> <code>
-sudo -u postgres /usr/lib/postgresql/16/bin/pg_checksums -P -e -D PGDATA+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>
- +
-- And 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.1724935730.txt.gz · Last modified: 2024/08/29 14:48 by jbi