Re: Excluding event triggers from a pg_dump

[Idelette Tchakounte <itchakounte@xxxxxxxxxxxx>]

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

Idelette Tchakounte Sr Database Administrator Advanced Call Center Technologies, LLC itchakounte@xxxxxxxxxxxx

---

From: Kenneth Barber <kbarber@xxxxxxxxxxxxxx>
Sent: Wednesday, June 19, 2024 11:18 AM
To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx>
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.