Raphael Bauduin wrote: > 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? There is no safe way (unless you were running on 9.3 with checksums). The best thing you can do is run a SELECT * from all tables and see if that succeeds. Also, rebuild all indexes if there are doubts whether they are valid or not. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
