On Thu, Jan 27, 2005 at 05:54:24 -0800,
Anil <anilby@xxxxxxxxx> 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?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
