Re: Scanning the PGSQL DB

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?