I have a server with PostgreSQL9.1-903 (Windows 7 Professional). After a power cut my database is inaccessible (I presume that the database is corrupted).
The postgreSQL service starts but the following message is displayed when I try to connect via
FATAL: catalog is missing 1 attribute(s) for relid 2662
I have tried to disable the option: 'ignore_system_index' but the database is still inaccessible. I guess that is not a problem with the indexes, but with the fact that some rows of the table pg_attribute have disappeared.
I am interested in recovering the data because my last backup is a bit old. Is there any way to just connect to the database? After that I would use the tool
pg_dump to retrieve the data and mount it in a new database.
fsync is commented in the
postgresql.conf (I assume that the default value is
on). Following, I attach the part of the
postgresql.conf which has been tuned:
checkpoint_segments = 32 # in logfile segments, min 1, 16MB each shared_buffers = 1GB # min 128kB work_mem = 8MB maintenance_work_mem = 256MB effective_cache_size=1024MB default_statistics_target = 200 autovacuum_vacuum_cost_delay = 50ms