Re: Diagnose Database Corruption - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Diagnose Database Corruption
Date
Msg-id 200306090121.h591Lu006161@candle.pha.pa.us
Whole thread Raw
In response to Diagnose Database Corruption  (Alex.H.Pollock@WellsFargo.COM)
List pgsql-admin
We don't have a checker because if it is corrupt, it will mention
something in the server logs or correct it automatically.  Corruption is
very rare, usually hardware flakiness.

---------------------------------------------------------------------------

Alex.H.Pollock@WellsFargo.COM wrote:
> Does PostgreSQL have a tool to diagnose and fix database corruption?  Is
> there any kind of database consistency checker?  I couldn't find anything in
> the doc...
>
> Thanks!
>
> Alex Pollock
> WFSC Data Services District
> Database Administration
> MAC A0186-032
> ( 415) 243-5931
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: "A.M."
Date:
Subject: table vs. view maximum columns
Next
From: Björn Metzdorf
Date:
Subject: Re: Uninitialized page - fixing