Sample Header Ad - 728x90

FATAL: catalog is missing 1 attribute(s) for relid 2662

4 votes
2 answers
14336 views
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 pg_Admin: >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. **EDIT** The parameter 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
Asked by Oscar (41 rep)
Nov 21, 2013, 12:47 AM
Last activity: Aug 22, 2023, 11:01 AM