From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tim White <tim.white2005@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump aborts with triggers error
Date: Wed, 02 Dec 2015 22:36:15 -0500
Message-ID: <8263.1449113775@sss.pgh.pa.us> (raw)
In-Reply-To: <CAK1tzNPiVdrTpzHU65jxwXSsrPXPkw76ZsqaQbSQ+g=wTF38gg@mail.gmail.com>
References: <CAK1tzNPiVdrTpzHU65jxwXSsrPXPkw76ZsqaQbSQ+g=wTF38gg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Tim White <tim.white2005@gmail.com> writes:
> My pg_dump is failing.
> PostgreSQL 8.3.7, compiled by gcc (unable to upgrade on this system)
I trust you're aware that this version is several years past its
five-year support lifespan. Please consider upgrading soon.
> pg_dump: reading triggers for table "gtrk"
> pg_dump: expected -31896 triggers on table "gtrk" but found 0
Ouch. Don't ordinary queries/updates on this table fail with comparable
complaints?
What this evidently means is that pg_class.reltriggers contains -31896
in the row for gtrk, when it should contain 0 (or, if not that, surely
something nonnegative, to wit the count of related entries in pg_trigger).
I'd try "select * from pg_class where relname = 'gtrk'" and look to see if
any of the other columns are obviously insane. If not, you might be able
to skate by with manually UPDATE'ing that column to zero (as a superuser).
But it's fairly uncommon for just one field in a table to randomly change
to something else. The odds are that there's more corruption elsewhere,
and that thought should scare you.
BTW, the last release in the 8.3 series was 8.3.23. Whether or not you
feel you can cope with updating to a new major-release series right now,
continuing to run 8.3.7 with data that is valuable to you is simply
irresponsible. Reasons why can be found in the release notes:
http://www.postgresql.org/docs/8.3/static/release.html
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, tim.white2005@gmail.com
Subject: Re: pg_dump aborts with triggers error
In-Reply-To: <8263.1449113775@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox