From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a tool for checking database integrity |
Date: | 2012-05-06 22:56:56 |
Message-ID: | 20120506225656.GB20147@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2012-05-06 23:07:08 | Re: Is there a tool for checking database integrity |
Previous Message | Tomas Vondra | 2012-05-06 22:37:47 | Re: Is there a tool for checking database integrity |