Search Postgresql Archives

Re: Is there a tool for checking database integrity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 to the last good backup?
> > Such a tool would guarantee me I am not sitting on a ticking time bomb
> > (corrupted database) without even noticing it.
> 
> 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.

Postgres 9.2 will _not_ support checksums.

-- 
  Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux