Hi Kenneth,
Yes you can do triggers only using the exclude command;
Pg_restore -U your_user -W--
disable-triggers -d your_database
your_database_backup.dump
Use disable trigger with pg_restore
Hope this help, Thanks
From: Kenneth Barber <kbarber@salesforce.com>
Sent: Wednesday, June 19, 2024 11:18 AM
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Excluding event triggers from a pg_dump
CAUTION
This is an external email originating from outside of ACT; do not click links or open attachments unless you know the content is safe.
Hi there,
Is there a way to exclude event triggers from a pg_dump?
I've been working around this by using a pg_restore --use-list with
the event triggers commented out using sed.
ken.