Re: Excluding event triggers from a pg_dump

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
[ACT] Idelette Tchakounte
Sr Database Administrator
Advanced Call Center Technologies, LLC
itchakounte(at)acttoday(dot)com<mailto:itchakounte(at)acttoday(dot)com>
________________________________
From: Kenneth Barber <kbarber(at)salesforce(dot)com>
Sent: Wednesday, June 19, 2024 11:18 AM
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)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.