Re: [GENERAL] [BUGS] Integrity check

2009-06-25 Thread Greg Stark
On Wed, Jun 24, 2009 at 11:45 PM, Scott Mead wrote: > >    If you're asking "Does the database have the ability to verify that > whatever is in a block is what was put into that block", then Oracle has > block check-summing (I'm not sure if this got into PG 8.4 or not...) It didn't, due to technic

Re: [GENERAL] [BUGS] Integrity check

2009-06-24 Thread Scott Mead
2009/6/23 David Fetter > On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote: > > Hello, > > > > Please can you assist on following questions. > > This is an issue for pgsql-general, where I'm redirecting this. > > > > * do you any tool to check postgreSQL database integrity check? > >

Re: [GENERAL] [BUGS] Integrity check

2009-06-24 Thread Albe Laurenz
David Fetter wrote: > > Please can you assist on following questions. > > This is an issue for pgsql-general, where I'm redirecting this. > > > > * 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

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Greg Stark
On Tue, Jun 23, 2009 at 2:00 PM, Dave Page wrote: > On Tue, Jun 23, 2009 at 1:38 PM, David Fetter 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 f

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread David Fetter
On Tue, Jun 23, 2009 at 02:30:50PM +0100, Dave Page wrote: > On Tue, Jun 23, 2009 at 2:26 PM, David Fetter wrote: > > >> Auditors can be a funny breed. > > > > They can, at that, but in this case, they're simply doing the > > normal human thing of trying to figure out whether there's a way > > the

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 2:26 PM, David Fetter wrote: >> Auditors can be a funny breed. > > They can, at that, but in this case, they're simply doing the normal > human thing of trying to figure out whether there's a way they can > push off their work to someone or something else.  In this case, th

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread David Fetter
On Tue, Jun 23, 2009 at 02:17:02PM +0100, Dave Page wrote: > On Tue, Jun 23, 2009 at 2:11 PM, David Fetter wrote: > > > 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. > > You

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 2:11 PM, David Fetter wrote: > 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. You don't have to tell me that :-) > Sometimes it's good not to agree with t

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread David Fetter
On Tue, Jun 23, 2009 at 02:00:51PM +0100, Dave Page wrote: > On Tue, Jun 23, 2009 at 1:38 PM, David Fetter 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

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 1:38 PM, David Fetter 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" tool

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread David Fetter
On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote: > Hello, > > Please can you assist on following questions. This is an issue for pgsql-general, where I'm redirecting this. > > * do you any tool to check postgreSQL database integrity check? No more than Oracle does. We get it rig