[ALUG] Re: Help! PostgreSQL corrupt system tables (Mark Rogers)

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