pgstat.stat corrupt

[T28333]

I keep getting a popup saying "C:\program files\postgreSQL\8.3.data\global\pgstat.stat is corrupt and unreadable. Please run the chkdsk utility."

What does this mean and how do I fix it?

[keggler]

firstly, run the chkdsk as recommended and see if that fixes the error...

if not, then i would back your database clusters off ASAP and collect your processed hand-histories somewhere safe... you would be best then to create a new empty database and try and restore the backup...

if that just restores the error again, then we have to set up a new database again and re-import your [saved] histories...

to backup, run this from a DOS command line in the postgres bin folder:

pg_dumpall -U postgres > c:\pgbackup

you'll have to enter your password a few times...

post back when you've done the chkdsk and backup...


susan

[T28333]

I ran chkdsk (which found no errors).

I ended up exporting the database, uninstalling PT and postgreSQL, reinstalling, creating a new database and importing from the exported histories. It seemed ok for a while, but I just started getting that error again.

This started happening right after I upgraded to build 15. (and when I did that, I did follow the instructions about vacuuming/analyzing/whatever else it said to do)

[keggler]

have you got a 2nd hard-drive you could try a new database on?


susan