Dear Adrian!
2018-03-20 15:47 GMT+01:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
https://www.postgresql.org/doc
When it would be useful?
s/10/static/app-pgrestore.html
"--disable-triggers
This option is relevant only when performing a data-only restore. It instructs pg_restore to execute commands to temporarily disable triggers on the target tables while the data is reloaded. Use this if you have referential integrity checks or other triggers on the tables that you do not want to invoke during data reload.
Presently, the commands emitted for --disable-triggers must be done as superuser. So you should also specify a superuser name with -S or, preferably, run pg_restore as a PostgreSQL superuser.
Firstly I supposed that data copy somehow could start the triggers - but how?
Which triggers? Or how they fired with this order?
I have read it, but I don't understand it.
Do you have a good example?
Thanks!
dd
