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
Last activity: Aug 22, 2023, 11:01 AM