On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
> On Tuesday 22 September 2009 7:28:03 pm Joe Kramer wrote:
>> I have database backup schema+data in text (non-compressed) format.
>> Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
>> I run it with "psql <dump.sql" but after restore all triggers are disabled!
>>
>> I can't use this text dump with pg_restore because it only accept
>> archived dumps. And I am not sure that using pg_restore will solve
>> disabled triggers problem.
>> I need to have the backup in text format so I can open and edit it.
>>
>> There was a recipe earlier in this mailing list that involves writing
>> a function that will enable all triggers one-by-one. But I want to do
>> it a proper way, without such "hacking".
>>
>> What would be the solution for me?
>>
>> Thanks.
>
> What version of Postgres are you dumping from, restoring to? Which version of
> pg_dump are you using?
>
> --
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.