create all indexes and triggers in a schema after bulk load

Поиск
Список
Период
Сортировка
От Akheel Ahmed
Тема create all indexes and triggers in a schema after bulk load
Дата
Msg-id 06fbb436-d81b-4428-029c-91e6f1181ed5@gmail.com
обсуждение исходный текст
Ответы Re: create all indexes and triggers in a schema after bulk load
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ryan Wexler
Дата:
Сообщение: postgresql 9.6x installers for windows are no longer available
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: create all indexes and triggers in a schema after bulk load