Обсуждение: Excluding event triggers from a pg_dump

Поиск
Список
Период
Сортировка

Excluding event triggers from a pg_dump

От
Kenneth Barber
Дата:
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.

Re: Excluding event triggers from a pg_dump

От
Idelette Tchakounte
Дата:
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
ACTIdelette Tchakounte
Sr Database Administrator
Advanced Call Center Technologies, LLC
itchakounte@acttoday.com
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.


Вложения