On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Joe Kramer <cckramer(at)gmail(dot)com> writes:
>> 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!
>
> You sure they weren't disabled in the source database? AFAICS pg_dump
> just duplicates the trigger state it sees in the source.
>
> regards, tom lane
>
Yes, I'm absolutely sure they are not disabled. And in the SQL dump
file there are no commands that would disable them.
It simply goes on to creating triggers, but in the end they are all disabled.
Regards.