PG_CHECKSUMS(1)

🎀 pg_checksums(1) — the checksum glow-up 🎀

okay bestie, welcome to the pg_checksums manual page from the PostgreSQL 14.24 Documentation. This is the tool that checks, enables, or disables data checksums in a PostgreSQL cluster, and yes, it is lowkey iconic. 💅

---

✨ NAME ✨

pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster. periodt. 🦋

---

🌸 SYNOPSIS 🌸

pg_checksums [option...] [[-D | --pgdata]datadir]

---

💖 DESCRIPTION 💖

So here’s the vibe: pg_checksums checks, enables or disables data checksums in a PostgreSQL cluster. The server must be shut down cleanly before running pg_checksums, no cap.

When verifying checksums, the exit status is zero if there are no checksum errors, and nonzero if at least one checksum failure is detected. When enabling or disabling checksums, the exit status is nonzero if the operation failed. That’s the whole mood. 😭

When verifying checksums, every file in the cluster is scanned. When enabling checksums, every file in the cluster is rewritten in-place. Disabling checksums only updates the file pg_control. Not me knowing the difference — slay. ✨

---

👑 OPTIONS 👑

The following command-line options are available, bestie:

• -D directory, --pgdata=directory — Specifies the directory where the database cluster is stored. Housekeeping but make it cute. 💖
• -c, --check — Checks checksums. This is the default mode if nothing else is specified. Main character default energy. ✅
• -d, --disable — Disables checksums. 💀
• -e, --enable — Enables checksums. 🔥
• -f filenode, --filenode=filenode — Only validate checksums in the relation with filenode filenode. Specific queen behavior. 🎀
• -N, --no-sync — By default, pg_checksums will wait for all files to be written safely to disk. This option causes pg_checksums to return without waiting, which is faster, but means that a subsequent operating system crash can leave the updated data directory corrupt. Generally, this option is useful for testing but should not be used on a production installation. This option has no effect when using --check. Red flag, bestie — testing only, fr fr. 🚩
• -P, --progress — Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums. We love a little progress moment. 📊
• -v, --verbose — Enable verbose output. Lists all checked files. Receipts for every single file. 🧾
• -V, --version — Print the pg_checksums version and exit. 🌈
• -?, --help — Show help about pg_checksums command line arguments, and exit. 🫶

---

🦋 ENVIRONMENT 🦋

• PGDATA — Specifies the directory where the database cluster is stored; can be overridden using the -D option. Default location tea. 📁
• PG_COLOR — Specifies whether to use color in diagnostic messages. Possible values are always, auto and never. Color coordination is literally self-care. 🌈

---

⭐ NOTES ⭐

Enabling checksums in a large cluster can potentially take a long time. During this operation, the cluster or other programs that write to the data directory must not be started or else data loss may occur. Do not start anything, bestie — data loss is not the vibe. 😭

When using a replication setup with tools which perform direct copies of relation file blocks (for example pg_rewind(1)), enabling or disabling checksums can lead to page corruptions in the shape of incorrect checksums if the operation is not done consistently across all nodes. When enabling or disabling checksums in a replication setup, it is thus recommended to stop all the clusters before switching them all consistently. Destroying all standbys, performing the operation on the primary and finally recreating the standbys from scratch is also safe. Consistency is the moment. 💅

If pg_checksums is aborted or killed while enabling or disabling checksums, the cluster’s data checksum configuration remains unchanged, and pg_checksums can be re-run to perform the same operation. No permanent damage, just re-run energy. 🫶

---

okay that’s the whole page, bestie. nothing skipped, nothing invented, all facts intact and looking cute. 💖

mwah 💋 — signing off with PostgreSQL 14.24, dated 2026, pg_checksums(1) energy. periodt. 👑✨