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@xxxxxxxxx> 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@xxxxxxxxxxx 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
