-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

PostgreSQL 14 Administration Cookbook
By :

In this recipe, we will use the data checksum feature to detect data corruption caused by I/O malfunctioning in advance.
It is important to discover such problems as soon as possible. For instance, we want a chance to recover lost data from one of our older backups, or we may want to stop data errors before they spread to the rest of the database when new data depends on existing data.
This feature is disabled by default, since it results in some overhead; it can be enabled when the cluster is initialized by using the --data-checksums
option of the initdb
utility, or on an existing cluster, with pg_checksum --enable
.
Also, before trying this recipe, you should be familiar with how to take backups and how to restore them afterward, which are the subjects of most of this chapter.
First, check whether data checksums are enabled:
postgres=# SHOW data_checksums ; data_checksums...
Change the font size
Change margin width
Change background colour