On Thu, Jan 27, 2005 at 05:54:24 -0800,
Anil <anilby(at)gmail(dot)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?