Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Destination Improvement: Disable trigger / index / constraints for postgres

Tushar Sharma User

We like to have new functionality to Disable trigger / index / constraints for postgres 

during Refresh and with integrate also So that it will not fire as part of integration and desired data comes with normal replication.

 

Also disabling will speed up refresh by avoiding extra work during activity.

This is business requirement where we are trying to migrate data from Sybase to Postgres and causing slowness due to trigger and indexes. 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Mark Van de Wiel User

    Hi Tushar,

    Let me find out if we can do this and if so, when we might slit this in.

    Thanks,
    Mark.

  • Mark Van de Wiel User

    Hi Tushar,

    You can disable trigger firing etc. using the following approach.

    Create an action Environment for the PostgreSQL destination, with:
    Name=HVR_SQL_INIT
    Value=SET session_replication_role = 'replica';

    Hope this helps.

    Mark.