Re: How to determine a database is intact?

Mike Nolan <nolan@gw.tssi.com>

From: Mike Nolan <nolan@gw.tssi.com>
To: lists@boutiquenumerique.com ( Pierre-Frédéric Caillaud )
Cc: pgsql-general@postgresql.org
Date: 2004-09-05T18:23:18Z
Lists: pgsql-general
> 	Doesn't a successful pg_dumpall prove the database is intact ?

It is very difficult to prove a negative, that there are no errors.
What a successful pg_dumpall says is that pg_dumpall didn't find any 
errors, not that there were none present.

Also, I thought part of the question was how to determine if the output
from the pg_dumpall was itself intact without doing a complete restore.
--
Mike Nolan