thanks. will give it a try
On 17/11/2021 5:16 pm, hubert depesz lubaczewski wrote:
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. rec
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
>
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 automati
