testing database consistency - Mailing list pgsql-admin

From Raphael Bauduin
Subject testing database consistency
Date
Msg-id CAONrwUGVR_-WwHWqYFAHk0jJEdGV7vEH6Qw2-Lgun2Hzbp53Bg@mail.gmail.com
Whole thread Raw
Responses Re: testing database consistency  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Re: testing database consistency  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: testing database consistency  (Alejandro Brust <alejandrob@pasteleros.org.ar>)
List pgsql-admin
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: Michael Schmiedgen
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance
Next
From: Rene Romero Benavides
Date:
Subject: Re: testing database consistency