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
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 |