Zero Downtime Upgrade

Hi Group What tools exist besides bucardo, londiste and rubyrep for logical replication to do a zero/near zero downtime upgrade? Thanks in advance

create all indexes and triggers in a schema after bulk load

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

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

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

Sorting difference in version 10 vs 13

Hi I have performed logical replication from a 10.18 to 13.4. in 13.4, order by asc gives underscores higher than other characters. all the LC parameters are identical across both instances. Am I missing anything else? Help appreciated. Thanks

Re: Sorting difference in version 10 vs 13

on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit (1 row) On 21/12/2021 3:12 pm, Tom Lane wrote: Akheel Ahmed writes: in 13.4, order by asc gives underscores higher than other characters. all the LC parameters are identical across both instances. Am I missing