Disabling foreign keys on AWS RDS.

[N-Putting]

As RDS does not support --disable-triggers is there any way to use set session_replication_role = replica; to disable it for each session? I tried it with a before and after data script but it won't work for jobs as it would need to run for each.

Here is an example how pgsync did it with another option. ankane/pgsync@88d17cd

[wwoytenko]

Hi! This will require a small code change, and I should be able to publish it this week. It looks like --disable-triggers might not be functioning correctly at the moment either. I’ll keep you posted.

[N-Putting]

Any update on this?

[wwoytenko]

@N-Putting
It is in progress. We aim to publish before new year.

[wwoytenko]

@N-Putting
PR #252 contains feature request

[wwoytenko]

#252 is merged

[wwoytenko]

@N-Putting let me know if it solves your request. Thanks in advance