Scanning the PGSQL DB - Mailing list pgsql-general

From Anil
Subject Scanning the PGSQL DB
Date
Msg-id 1106834064.903508.211560@f14g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: Scanning the PGSQL DB
List pgsql-general
Hi,

I am using PSQL on RedHat Linux 6.2...version given below.
[PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.6]

I inserted a new DB with somewhere around 200 tables and each table
having some 100 entries. The table insertion went fine.
But I wanted to know whether the DB is perfect ...I mean my DB is not
corrupted. Are there any tools/commands to check whether my DB is not
corrupted?

Once I did a kill -9 <postgres pids> and my DB got corrupted. I am
looking
for some tools that will say the status of my DB.
Thanks in advance,
Anil.


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: more information for SRF function
Next
From: Rogério A Bassete
Date:
Subject: complete instruction in trigger?