25 Oct
2005
25 Oct
'05
12:12 p.m.
Mark Rogers wrote:
One of my customers has a corrupt postgreSQL system database. The error he's getting is:
template1=# select * from pg_database; ERROR: invalid page header in block 1 of relation "pg_database"This happens at any point where postgres is trying to access the database catalog, not for invididual db access but (for example) trying to create / drop any databases.
I can't help him as I know nearly nothing about Postgres (although its about time I learnt).
Hi Mark, I asked my brother for you and he says:
pg_dumpall
new database install
restore all databases
might do it
HTH Jen