pg_dump aborts with triggers error

From: Tim White <tim(dot)white2005(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump aborts with triggers error
Date: 2015-12-03 00:33:41
Message-ID: CAK1tzNPiVdrTpzHU65jxwXSsrPXPkw76ZsqaQbSQ+g=wTF38gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everyone!

My pg_dump is failing.

PostgreSQL 8.3.7, compiled by gcc (unable to upgrade on this system)

CentOS release 5.9 32-bit

Command and output:

root(at)ryenguis ~# pg_dump -vt gtrk urr > smackfile
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined operator families
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "gtrk"
pg_dump: finding default expressions of table "gtrk"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "gtrk"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "gtrk"
pg_dump: reading triggers
pg_dump: reading triggers for table "gtrk"
pg_dump: expected -31896 triggers on table "gtrk" but found 0
pg_dump: *** aborted because of error

How do I fix the triggers error? A pg_dump works if I do an
--exclude-table=gtrk

---

-Tim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2015-12-03 02:04:32 Re: Major version upgrades + Replication
Previous Message Laszlo Fogas 2015-12-02 20:03:48 Adding PK using INDEX is taking time