Re: Scanning the PGSQL DB - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Scanning the PGSQL DB
Date
Msg-id 20050129221428.GA14571@wolff.to
Whole thread Raw
In response to Scanning the PGSQL DB  ("Anil" <anilby@gmail.com>)
Responses Re: Scanning the PGSQL DB
List pgsql-general
On Thu, Jan 27, 2005 at 05:54:24 -0800,
  Anil <anilby@gmail.com> wrote:
>
> 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?

No specific ones. You can always do normal selects and see if you get
the results you expected.

> 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.

That should not happen. Were you running with syncing disabled?

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: inet-type sequence
Next
From: PFC
Date:
Subject: Re: Splitting queries across servers