Skip site navigation (1) Skip section navigation (2)

Re: Database consistency checker

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Richard Harris" <Richard_Harris(at)adp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database consistency checker
Date: 2004-03-29 23:13:46
Message-ID: 14459.1080602026@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Richard Harris" <Richard_Harris(at)adp(dot)com> writes:
> <P><FONT SIZE=3D2 FACE=3D"Arial">Does PosgreSQL has a capability to check t=
> he internal consistency of tables and and indexes, i.e., a tool like the DB=
> CC capability in MS SQL Server? If so, where is it documented?</FONT></P>

(Please don't use HTML in postings to the PG lists.)

We do not have any automatic database verifiers.  In general there are
no known repeatable failure modes in Postgres, and thus not a lot of
scope for tools that look for such errors ... we prefer to spend our
development efforts on making the system bulletproof in the first place ;-)

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Christopher BrowneDate: 2004-03-30 04:00:32
Subject: Re: Raw vs Filesystem
Previous:From: Richard HarrisDate: 2004-03-29 22:41:13
Subject: Database consistency checker

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group