ICU Collations and Collation Updates

2025-04-14 Thread Thomas Michael Engelke
Good morning, long time reader, first time writer. Where I currently work my colleagues used libc collations before I arrived. While using libc collations, they stumbled upon the collation update problem after SLES updates (15.4 to 15.5) (collation version difference for database and operating sy

Replicate consistent snapshot to a second PG instance using FDWs

2022-01-05 Thread Thomas Michael Engelke
We have a setup where we run 2 locations with both locations containing a full HA setup (using Patroni, etcd, Consul). Each location has 2 PG servers + 1 witness node. At certain time intervals or on demand, our customer would want to send the data from one location to the other over the wir