Hi,
On Thu, Nov 07, 2019 at 12:52:17PM -0700, Scott Ribe wrote:
> > On Nov 7, 2019, at 12:16 PM, Asomba Djala <asombadjala8@gmail.com> wrote:
> > Thank you. What about already initialized clusters?
>
> I believe PG 12 adds the feature that checksums can be added to existing clusters???
Right, it's the pg_checksums program.
> Probably requires taking the cluster down, and won't detect existing corruption...
It does require taking the instance down for checkusm activation and can
only checksum what is already there.
Another option is to pg_dump to /dev/null in order to check for logical
data consistency if you are not doing regular logical backups.
Michael
--
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax: +49 2166 9901-100
Email: michael.banck@credativ.de
credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz