Got a lot of "canceling statement due to conflict with recovery" and "Deadlock detected" Errors when sync the database

[HieronyM]

I was trying to sync my production database to the dev environment, but I keep getting a lot of errors like "canceling statement due to conflict with recovery", "Deadlock detected" and "violates foreign key constraint"

Is there anything I can do to minimize the error? maybe setting up some parameter or some configuration on the source or target database?

[ankane]

Hi @HieronyM, check out this for how to address canceling statement due to conflict with recovery and the readme for options on foreign keys.