Joe Kramer <cckramer@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
