The Postgres Operator easily lets you automate your Postgres in Kubernetes, whether it's one or thousands of instances.

Fun with pg_checksums

submited by
Style Pass
2021-07-01 21:30:08

The Postgres Operator easily lets you automate your Postgres in Kubernetes, whether it's one or thousands of instances.

Integrated high availability PostgreSQL solution for enterprises with always on requirements.

Hardened, secure, access controlled PostgreSQL to meet advanced security requirements.

Data checksums are a great feature in PostgreSQL. They are used to detect any corruption of the data that Postgres stores on disk. Every system we develop at  Crunchy Data  has this feature enabled by default. It's not only Postgres itself that can make use of these checksums. Some third party tools such as the awesome  pgBackRest program  can also use them for enhanced data integrity.

Sadly, enabling data checksums is still not the default behavior when creating a new Postgres cluster. When you invoke the  initdb  program, add the  ‑‑data‑checksums  flag (or  ‑k  if you prefer obscure arguments), and your shiny new Postgres cluster will have data checksums enabled.

Leave a Comment