X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 55191D1E9FA for ; Mon, 29 Mar 2004 23:13:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 41729-07 for ; Mon, 29 Mar 2004 19:13:48 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 00A3CD1E9F0 for ; Mon, 29 Mar 2004 19:13:45 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2TNDlN3014460; Mon, 29 Mar 2004 18:13:47 -0500 (EST) To: "Richard Harris" Cc: pgsql-admin@postgresql.org Subject: Re: Database consistency checker In-reply-to: References: Comments: In-reply-to "Richard Harris" message dated "Mon, 29 Mar 2004 14:41:13 -0800" Date: Mon, 29 Mar 2004 18:13:46 -0500 Message-ID: <14459.1080602026@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/380 X-Sequence-Number: 12949 "Richard Harris" writes: >

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?

(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