HPE Community
Operating System - Linux
1843873 Members
6928 Online
110225 Solutions
New Discussion

testing a postgres dump file

 
Andrew Kaplan
Super Advisor

‎05-13-2010 07:48 AM

‎05-13-2010 07:48 AM

testing a postgres dump file

Hi there --

We are going through the motions of testing the backup and restore setups of our postgres database. The version of the database software is the HP-UX A.6.00-8.1.3.1 package.

One idea was testing the viability of the dump file. Does anyone know of a way of testing the dump file to determine if there is any corruption in it? Thanks.
A Journey In The Quest Of Knowledge
0 Kudos
Reply
1 REPLY 1
Ivan Ferreira
Honored Contributor

‎05-13-2010 10:52 AM

‎05-13-2010 10:52 AM

Re: testing a postgres dump file

I think that the only valid test is restoring and opening the database to validate the backup.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.