Re: testing database consistency - Mailing list pgsql-admin

From Alejandro Brust
Subject Re: testing database consistency
Date
Msg-id 5277F277.3090705@pasteleros.org.ar
Whole thread Raw
In response to testing database consistency  (Raphael Bauduin <rblists@gmail.com>)
List pgsql-admin
Hi,
U could try to perform many task over the running copy
like pg_dump + pg_restore + vacuumdb + reindexdb.... ,etc
If all of them  went ok U could make several select of yours best known
tables and compare them with the original one.


see U



El 24/10/2013 04:18, Raphael Bauduin escribió:
> Hi,
>
> I have a postgresql running in a virtual machine (linux, kvm).
> I wanted to test that the backup, which takes a copy of the disk
> image, is valid and usable.
>
> I have taken a copy of the disk image and run it fine on another computer.
> However, just starting the server succesfully does not mean there is
> no corrupted data in the database. This is why I'm looking to a way to
> validate that all the data stored in the postgresql is ok, ie
> consistent and usable. Does anyone have advices on how to best check
> the validity of the whole database?
>
> Thanks in advance!
>
> Raphaël



pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: testing database consistency
Next
From: Victor Tan
Date:
Subject: BI tools and PostgreSQL