Re: create all indexes and triggers in a schema after bulk load

2021-11-16 Thread Akheel Ahmed
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

Re: create all indexes and triggers in a schema after bulk load

2021-11-16 Thread hubert depesz lubaczewski
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 >