Re: [BUGS] Integrity check

From: Dave Page <dpage(at)pgadmin(dot)org>
To: David Fetter <david(at)fetter(dot)org>
Cc: "Prasad, Venkat" <venkat(dot)prasad(at)credit-suisse(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [BUGS] Integrity check
Date: 2009-06-23 13:00:51
Message-ID: 937d27e10906230600h1d74902cme459032dda5b6f5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Fetter 2009-06-23 13:11:17 Re: [BUGS] Integrity check
Previous Message David Fetter 2009-06-23 12:38:42 Re: [BUGS] Integrity check

Browse pgsql-general by date

  From Date Subject
Next Message darioteixeira 2009-06-23 13:07:22 Re: Information about columns
Previous Message Dario Teixeira 2009-06-23 12:47:10 Re: Information about columns