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

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: 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

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

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