Skip site navigation (1) Skip section navigation (2)

crash problem

From: terry(at)greatgulfhomes(dot)com
To: "Postgres (E-mail)" <pgsql-docs(at)postgresql(dot)org>
Subject: crash problem
Date: 2002-06-21 01:29:31
Message-ID: 000001c218c3$18736420$ (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-general
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
           Table "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      |
Indices: pg_trigger_tgconstrname_index,

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
terminated unexpectedly".

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.


Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes


pgsql-docs by date

Next:From: terryDate: 2002-06-21 02:42:22
Subject: FW: crash problem
Previous:From: Bruce MomjianDate: 2002-06-20 20:24:18
Subject: Re: Copyright notice

pgsql-general by date

Next:From: Alvaro HerreraDate: 2002-06-21 01:36:06
Subject: Re: database size
Previous:From: Alvaro HerreraDate: 2002-06-21 00:51:00
Subject: Re: Serious Crash last Friday

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group