consistency checks - Mailing list pgsql-admin

From Laurette Cisneros
Subject consistency checks
Date
Msg-id Pine.LNX.4.44.0302061000420.7401-100000@visor.corp.nextbus.com
Whole thread Raw
List pgsql-admin
We had an out of space problem that affected the 7.3.1 server we are running.
Some tables in various databases were being restored and there are
continuously running processes that insert data into several tables fairly
often.  We have 30+ databases on this server.

My question is this: how do I find if there was any corruption in the data
for those tables?  Will vacuum find this out?  Is there some other tool
that can be used to "hunt down" corruption?  This is to double check if any
harm was done by the out of space event.

Thanks,

--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"No man is wise enough by himself"
-- Titus Maccius Plautus
   (254 Bc - 184 BC), Miles Gloriosus


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems upgrading from 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: pg_restore problem with 7.3.1