System Administration
Showing results for 
Search instead for 
Did you mean: 

testing a postgres dump file

Andrew Kaplan
Super Advisor

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- 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
Ivan Ferreira
Honored Contributor

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?