create all indexes and triggers in a schema after bulk load

Akheel Ahmed <akheel.mailing.list@xxxxxxxxx> · Wed, 17 Nov 2021 17:13:35 +1000



    Hi Group
    I am looking at
        doing a CDC-based upgrade using the following steps:
    

    1. pg_dump schema
        on source, but exclude indexes and triggers

      
    2. recreate schema
        on target
    3. Do a full load
        from source to target

      
    4. Recreate all the
        indexes and triggers on the target
    The migration will
        automatically switch from full load to CDC when all tables are
        fully loaded. 

      
    Is there a way to
        just recreate all indexes and triggers using a separate pg_dump
        on source to capture the ddl and then run it on the target?
    Please advise
    Thanks