Re: Check for logical / physical corruption

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: flumbador(at)virgilio(dot)it, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Check for logical / physical corruption
Date: 2018-01-25 16:37:37
Message-ID: 1516898257.2599.17.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

flumbador(at)virgilio(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2018-01-25 17:01:36 Re: Upgrade and re-synchronization with logical replication (pglogical and PG 10)
Previous Message flumbador 2018-01-25 12:30:40 Check for logical / physical corruption