On Tue, Jun 23, 2009 at 1:38 PM, David Fetter<david@fetter.org> wrote:
> On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
>> * do you any tool to check postgreSQL database integrity check?
>
> No more than Oracle does. We get it right in the first place. The
> existence of "integrity checking" tools means the DBMS is done with
> high incompetence.
>
>> * how do we confirm that dump file is proper data?
>
> See above.
Whilst I don't disagree with the sentiment, that sort of answer is
unlikely to impress auditors in my experience. Annoyingly they tend to
want you to be able to prove to them that your backups are good.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com