Re: [BUGS] Integrity check

On Tue, Jun 23, 2009 at 02:00:51PM +0100, Dave Page wrote:
> On Tue, Jun 23, 2009 at 1:38 PM, David Fetter<david(at)fetter(dot)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.

There is no general way to do that, apart from creating a test suite
specific to your scenario and hoping it doesn't have more bugs that
the thing it's testing.

Sometimes it's good not to agree with the premises underlying a
question, and I believe this is one of those times.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate