| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Akheel Ahmed <akheel(dot)mailing(dot)list(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: create all indexes and triggers in a schema after bulk load |
| Date: | 2021-11-17 07:16:44 |
| Message-ID: | 20211117071643.GA11260@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 17, 2021 at 05:13:35PM +1000, Akheel Ahmed wrote:
> 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?
There is no need for separate pg_dump.
Just dump once, with -Fc, or (better) -Fd, and then use pg_restore
-l/-L.
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Akheel Ahmed | 2021-11-17 07:18:57 | Re: create all indexes and triggers in a schema after bulk load |
| Previous Message | Akheel Ahmed | 2021-11-17 07:13:35 | create all indexes and triggers in a schema after bulk load |