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