Re: [ADMIN] FATAL: catalog is missing attributes

2006-04-29 Thread Bruno Cortes
Yes I suppose that was the problem...the harwdare failure was responsible for the corrupted pg_attribute. But I was suprise because I had a RAID 0/1 and the data got corrupted on the second disk as well. I am now trying to restore things from last backup and transaction logs. Thanks all. Regards

Re: [ADMIN] FATAL: catalog is missing attributes

2006-04-24 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Bruno Cortes wrote: >> 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 a

Re: [ADMIN] FATAL: catalog is missing attributes

2006-04-24 Thread Jim C. Nasby
On Mon, Apr 24, 2006 at 08:43:26AM -0400, Alvaro Herrera wrote: > 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 VACU

Re: [ADMIN] FATAL: catalog is missing attributes

2006-04-24 Thread Alvaro Herrera
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 e

[ADMIN] FATAL: catalog is missing attributes

2006-04-24 Thread Bruno Cortes
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