Check for logical / physical corruption

From: flumbador(at)virgilio(dot)it
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Check for logical / physical corruption
Date: 2018-01-25 12:30:40
Message-ID: 153589807.1971336.1516883440396@mail.virgilio.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

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?

Thanks in advance

Regards

Gabriele Fagnani

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-01-25 16:37:37 Re: Check for logical / physical corruption
Previous Message Azimuddin Mohammed 2018-01-25 07:36:49 Re: Postgres for hadoop