Hi, I am using PostgreSQL 9.2 and while trying to vacuum db named mcfdb3, i am getting below error.
DETAIL: 0 index row versions were removed. 110 index pages have been deleted, 110 are currently reusable. CPU 0.02s/0.00u sec elapsed 0.03 sec. INFO: index "i1409226645953" now contains 374682 row versions in 3267 pages DETAIL: 0 index row versions were removed. 1436 index pages have been deleted, 1436 are currently reusable. CPU 0.01s/0.00u sec elapsed 0.01 sec. vacuumdb: vacuuming of database "mcfdb3" failed: ERROR: invalid page header in block 15871 of relation base/17148/30976 DETAIL: 0 index row versions were removed. 110 index pages have been deleted, 110 are currently reusable. CPU 0.02s/0.00u sec elapsed 0.03 sec. INFO: index "i1409226645953" now contains 374682 row versions in 3267 pages DETAIL: 0 index row versions were removed. 1436 index pages have been deleted, 1436 are currently reusable. CPU 0.01s/0.00u sec elapsed 0.01 sec. vacuumdb: vacuuming of database "mcfdb3" failed: ERROR: invalid page header in block 15871 of relation base/17148/30976 Please help. Regards, Lalit.
