Re: How to verify pg_dump files - Mailing list pgsql-general

From Lists
Subject Re: How to verify pg_dump files
Date
Msg-id 509AE132.7050801@benjamindsmith.com
Whole thread Raw
In response to Re: How to verify pg_dump files  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
On 11/07/2012 11:56 AM, Igor Neyman wrote:
> The only 100% fool-proof test would be to restore from your backup files.
>
> Regards,
> Igor Neyman
Our internal process is to back up production databases regularly, and
then use the backups offsite to populate  copies of databases for
developer use. This allows us to test with real data, identifying real
world bugs that would not appear with often-limited, manually created,
"sample data", as well as verify our backups on a regular, daily basis.

I'd strongly recommend something similar if it works for you.

-Ben


pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Plug-pull testing worked, diskchecker.pl failed
Next
From: Greg Smith
Date:
Subject: Re: Unexpectedly high disk space usage