Scanning the PGSQL DB

From: "Anil" <anilby(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Scanning the PGSQL DB
Date: 2005-01-27 13:54:24
Message-ID: 1106834064.903508.211560@f14g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2005-01-27 14:02:00 An interesting pgpool benchmark result
Previous Message Stephan Szabo 2005-01-27 13:35:40 Re: [SQL] Foreign Key relationship between two databases