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