pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase consistency checker
2+ messages / 2 participants
[nested] [flat]
* Database consistency checker
@ 2004-03-29 22:41 Richard Harris <Richard_Harris@adp.com>
2004-03-29 23:13 ` Re: Database consistency checker Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Richard Harris @ 2004-03-29 22:41 UTC (permalink / raw)
To: pgsql-admin
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>Database consistency checker</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Does PosgreSQL has a capability to check the internal consistency of tables and and indexes, i.e., a tool like the DBCC capability in MS SQL Server? If so, where is it documented?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Rich Harris</FONT>
</P>
</BODY>
</HTML>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Database consistency checker
2004-03-29 22:41 Database consistency checker Richard Harris <Richard_Harris@adp.com>
@ 2004-03-29 23:13 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-03-29 23:13 UTC (permalink / raw)
To: Richard Harris <Richard_Harris@adp.com>; +Cc: pgsql-admin
"Richard Harris" <Richard_Harris@adp.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-29 23:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-29 22:41 Database consistency checker Richard Harris <Richard_Harris@adp.com>
2004-03-29 23:13 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox