Re: FATAL: catalog is missing attributes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bruno Cortes wrote:
> Hi,
> 
> I was trying to make a dump from a database in postgresql 7.4.2-1. I was 
> enable to do so because of a cache lookup problem.
> To solve it, I enter the database as superuser and execute VACUUM ALL. 
> This was even worse than the previous error. Right now I cannot enter 
> the database neither make a dump. When I execute a command such as "psql 
> -U postgres center-01" I get the error:
> psql: FATAL:  catalog is missing 10 attribute(s) for relid 1262

Sounds very much like you haven't been doing the required vacuum on all
system catalogs.  Look for "transaction Xid wraparound" for possible
suggestions.  For example look at

http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux