Re: Help! Database restored with disabled triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Kramer <cckramer(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help! Database restored with disabled triggers
Date: 2009-09-23 15:24:21
Message-ID: 1703.1253719461@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Kramer <cckramer(at)gmail(dot)com> writes:
> On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver <aklaver(at)comcast(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-09-23 15:32:25 Re: Advance SQL subquery
Previous Message Ms swati chande 2009-09-23 15:21:10