My database crashed earlier. It's starts up fine, and I can use it, but I
cannot back it up, it reports this error:
bash$ pg_dump -t letter_tag_execute_types devtest >
getTables(): SELECT (for TRIGGER) failed. Explanation from backend: 'ERROR:
such attribute or function 'tgdeferrable'
I get the same error if I try to do dumpall.
I try looking at the triggers table and this is what I get:
devtest=# select * from pg_trigger;
ERROR: Relation pg_trigger does not have attribute
devtest=# \d pg_trigger
Attribute | Type | Modifier
tgrelid | oid |
tgname | name |
tgfoid | oid |
tgtype | smallint |
tgenabled | boolean |
tgisconstraint | boolean |
tgconstrname | name |
tgconstrrelid | oid |
tginitdeferred | boolean |
tgnargs | smallint |
tgattr | int2vector |
tgargs | bytea |
I ran a vacuum, and it did worked, but did not fix this corruption problem.
Nothing meaningful appears in the log, just messages about the "backend
What do I do now? I was hoping to upgrade to 7.2.1 this weekend, but if I
cannot back it up again, I will loose all of todays work, which was pretty
significant, I added much tables and populated a bunch also.
Any ideas is appreciated.
Great Gulf Homes / Ashton Woods Homes
pgsql-docs by date
|Next:||From: terry||Date: 2002-06-21 02:42:22|
|Subject: FW: crash problem|
|Previous:||From: Bruce Momjian||Date: 2002-06-20 20:24:18|
|Subject: Re: Copyright notice|
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2002-06-21 01:36:06|
|Subject: Re: database size|
|Previous:||From: Alvaro Herrera||Date: 2002-06-21 00:51:00|
|Subject: Re: Serious Crash last Friday|