Re: Help! Database restored with disabled triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: Help! Database restored with disabled triggers
Date
Msg-id 1703.1253719461@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help! Database restored with disabled triggers  (Joe Kramer <cckramer@gmail.com>)
List pgsql-general
Joe Kramer <cckramer@gmail.com> writes:
> On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver <aklaver@comcast.net> wrote:
>> What version of Postgres are you dumping from, restoring to? Which version of

> I am using client 8.1.9 to dump from server 8.3.0  (unable to use client 8.3.x)
> Importing to server 8.3.7.

You mean you are dumping from an 8.3 server with an 8.1 pg_dump?
That is pretty much guaranteed not to work; I am surprised that the
only symptom you notice is bad trigger state.  Why do you feel
you can't use an up-to-date pg_dump?

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Kramer
Date:
Subject: Re: Help! Database restored with disabled triggers
Next
From: AnthonyV
Date:
Subject: Advance SQL subquery