Invalid page header in database is getting common

[AKQJ10]

As I understand it, "invalid page header" indicates DB corruption. I was having frequent issues with this, so about a week ago, I uninstalled Postgres and reinstalled it completely.

It doesn't seem to be helping. If I don't back up my HM data every few hours, I end up with corruption.

Is database size a potential problem? (I need to prune my db, I think.)

[Patvs]

Three things to look at:
-1 harddisk/database management:
run a scandisk/defrag on your harddisk--> maybe you have a couple of bad clusters
--> vacuum/analyse your database frequently

-2 update SQL using the manual installer at PostgreSQL: The world's most advanced open source database
Most recent version is 8.4.4.

-3 database size usually only becomes a problem when the database is 20+ GB
try purging observed hands

[AKQJ10]

Thanks.

I'd already run chkdsk a while back, and again recently, so that should be OK. But I suspect I'm having other hard-drive related issues related to this drive (I forget the name - an alternative to SATA, supposed to be much faster) that the guy who fixed my computer put in.

I just tried the Postgres upgrade so we'll see if that fixes anything.