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@xxxxxxxxxx> 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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
