From: Michael Banck <michael.banck@credativ.de>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Asomba Djala <asombadjala8@gmail.com>
Cc: abbas alizadeh <ramkly@yahoo.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Database consistency check.
Date: Thu, 14 Nov 2019 15:45:36 +0100
Message-ID: <20191114144536.GG28958@nighthawk.caipicrew.dd-dns.de> (raw)
In-Reply-To: <E9549E91-756F-4726-9EB0-A35FC7A292F8@elevated-dev.com>
References: <CAOdgZeRFyXPL4knBetHsqWmk2OMauvqK5RoWcU7gOGF82HCzyQ@mail.gmail.com>
<632596C8-5333-478E-8C4C-1CE486DC339F@yahoo.com>
<CAOdgZeTDy_KeqTZE9evxrSKJyV-LkFgcniKtRk2xsR0ftkZEkQ@mail.gmail.com>
<E9549E91-756F-4726-9EB0-A35FC7A292F8@elevated-dev.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael.banck@credativ.de, scott_ribe@elevated-dev.com, asombadjala8@gmail.com, ramkly@yahoo.com
Subject: Re: Database consistency check.
In-Reply-To: <20191114144536.GG28958@nighthawk.caipicrew.dd-dns.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox