From: Laurenz Albe <laurenz.albe@cybertec.at>
To: flumbador@virgilio.it
To: pgsql-admin@lists.postgresql.org
Subject: Re: Check for logical / physical corruption
Date: Thu, 25 Jan 2018 17:37:37 +0100
Message-ID: <1516898257.2599.17.camel@cybertec.at> (raw)
In-Reply-To: <153589807.1971336.1516883440396@mail.virgilio.it>
References: <153589807.1971336.1516883440396@mail.virgilio.it>
flumbador@virgilio.it wrote:
> I need to check that my database has not physical / logical corruption.
> I think that "vacuumdb -all -freeze -analyze" will do this for me.
> Am I right?
> Are there other command / utility that I should do to check corruptions?
The only good test is to run a pg_dumpall and restore the dump into a new
PostgreSQL cluster.
Yours,
Laurenz Albe
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: laurenz.albe@cybertec.at, flumbador@virgilio.it, pgsql-admin@lists.postgresql.org
Subject: Re: Check for logical / physical corruption
In-Reply-To: <1516898257.2599.17.camel@cybertec.at>
* 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