Re: [GENERAL] How to verify pg_dump files

2012-11-07 Thread Lists
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

Re: [GENERAL] How to verify pg_dump files

2012-11-07 Thread Ryan Delaney
On Wed, Nov 7, 2012 at 10:11 AM, Raymond O'Donnell 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 the

Re: [GENERAL] How to verify pg_dump files

2012-11-07 Thread Raymond O'Donnell
On 07/11/2012 18:57, Ryan Delaney wrote: > On Wed, Nov 7, 2012 at 10:11 AM, Raymond O'Donnell > 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

Re: [GENERAL] How to verify pg_dump files

2012-11-07 Thread Igor Neyman
> -Original Message- > From: Gary [mailto:listgj...@yahoo.co.uk] > Sent: Wednesday, November 07, 2012 8:02 AM > To: pgsql-general@postgresql.org > 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

Re: [GENERAL] How to verify pg_dump files

2012-11-07 Thread Raymond O'Donnell
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 outpu