PDA

View Full Version : Invalid page header in database is getting common



AKQJ10
08-07-2010, 11:38 AM
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
08-07-2010, 09:13 PM
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 (http://www.postgresql.org)
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
08-11-2010, 01:15 PM
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.