Re: How to verify pg_dump files

On 07/11/2012 18:57, Ryan Delaney wrote:
> On Wed, Nov 7, 2012 at 10:11 AM, Raymond O'Donnell <rod@iol.ie
> <mailto:rod@iol.ie>> wrote:
>
>     On 07/11/2012 13:01, Gary wrote:
>     > Can anyone suggest how I could verify that the files created by
>     pg_dump
>     > are "okay"? They are being created for backup purposes, and the last
>     > thing I want to do is find out that the backups themselves are in some
>     > way corrupt.
>     >
>     > I know I can check the output of the command itself, but what if.. I
>     > don't know... if there are problems with the disc it writes to, or
>     > something like that. Is there any way to check whether the output file
>     > is "valid" in the sense that it is complete and syntactically correct?
>
>     Reload it and test your application against it?
>
>     Ray.
>
>
>     --
>     Raymond O'Donnell :: Galway :: Ireland
>     rod@iol.ie <mailto:rod@iol.ie>
>
>
> Would that entail over-writing good data with possibly bad data?

No, reload your database into a newly-created database - on a test
server, not on the production server!

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie