How to verify pg_dump files

From: Gary <listgj-pg(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: How to verify pg_dump files
Date: 2012-11-07 13:01:41
Message-ID: k7dm3k$nv6$2@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Gary Please do NOT send me 'courtesy' replies off-list.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message markalcock 2012-11-07 14:30:23 Re: Postgres no longer starts
Previous Message Albe Laurenz 2012-11-07 10:48:23 Re: How to evaluate "explain analyze" correctly soon after "explain" for the same statement ?