Re: [GENERAL] Is there a tool for checking database integrity

2012-05-07 Thread Clemens Eisserer
HI Tomas, >> No, at least in the current version. The next version (9.2) will support >> checksums, but it's meant mostly as a protection against failures at the >> I/O level. It might catch some memory issues, but it certainly won't be >> 100% protection. > >Oh, I see - it was bumped to 9.3 and

Re: [GENERAL] Is there a tool for checking database integrity

2012-05-06 Thread Tomas Vondra
On 7.5.2012 00:56, Bruce Momjian wrote: > On Mon, May 07, 2012 at 12:37:47AM +0200, Tomas Vondra wrote: >> Hi, >> >> On 6.5.2012 20:47, Clemens Eisserer wrote: >>> Hi, >>> >>> Is there a tool for checking a postgresql database for integrity, so I >>> would be notified immediatly if something went w

Re: [GENERAL] Is there a tool for checking database integrity

2012-05-06 Thread Bruce Momjian
On Mon, May 07, 2012 at 12:37:47AM +0200, Tomas Vondra wrote: > Hi, > > On 6.5.2012 20:47, Clemens Eisserer wrote: > > Hi, > > > > Is there a tool for checking a postgresql database for integrity, so I > > would be notified immediatly if something went wrong e.g. with memory > > and can go back t

Re: [GENERAL] Is there a tool for checking database integrity

2012-05-06 Thread Tomas Vondra
Hi, On 6.5.2012 20:47, Clemens Eisserer wrote: > Hi, > > Is there a tool for checking a postgresql database for integrity, so I > would be notified immediatly if something went wrong e.g. with memory > and can go back to the last good backup? > Such a tool would guarantee me I am not sitting on a

[GENERAL] Is there a tool for checking database integrity

2012-05-06 Thread Clemens Eisserer
Hi, Is there a tool for checking a postgresql database for integrity, so I would be notified immediatly if something went wrong e.g. with memory and can go back to the last good backup? Such a tool would guarantee me I am not sitting on a ticking time bomb (corrupted database) without even noticin