> -----Original Message----- > From: Gary [mailto:listgj-pg@xxxxxxxxxxx] > Sent: Wednesday, November 07, 2012 8:02 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: How to verify pg_dump files > > 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. > The only 100% fool-proof test would be to restore from your backup files. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general