create all indexes and triggers in a schema after bulk load

From: Akheel Ahmed <akheel(dot)mailing(dot)list(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: create all indexes and triggers in a schema after bulk load
Date: 2021-11-17 07:13:35
Message-ID: 06fbb436-d81b-4428-029c-91e6f1181ed5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-11-17 07:16:44 Re: create all indexes and triggers in a schema after bulk load
Previous Message Ryan Wexler 2021-11-17 05:44:07 postgresql 9.6x installers for windows are no longer available