From: Alejandro Brust <alejandrob@pasteleros.org.ar>
To: pgsql-admin@postgresql.org
Subject: Re: testing database consistency
Date: Mon, 04 Nov 2013 16:16:07 -0300
Message-ID: <5277F277.3090705@pasteleros.org.ar> (raw)
In-Reply-To: <CAONrwUGVR_-WwHWqYFAHk0jJEdGV7vEH6Qw2-Lgun2Hzbp53Bg@mail.gmail.com>
References: <CAONrwUGVR_-WwHWqYFAHk0jJEdGV7vEH6Qw2-Lgun2Hzbp53Bg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alejandrob@pasteleros.org.ar
Subject: Re: testing database consistency
In-Reply-To: <5277F277.3090705@pasteleros.org.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox