![[?]](https://social.dk-libre.fr/social/oldsysops/s/7e93fa6bf16b47da4f57ddf9072aff8c.png)
#askfedi : when you refresh collation on a #postgresql database after an os upgrade, is there a way to refresh collation on the replicate without launching a full pg_basebackup ?
...
![[?]](https://media.hachyderm.io/accounts/avatars/110/951/731/365/927/189/original/b2c68992ae4f02d2.jpg)
@oldsysops If it's a physical replica, the database collation is updated on the replica as soon as you update the primary.
...
0 ★ 0 ↺
@jriou@hachyderm.io yes,
i've just figure out that i forgot to upgrade the secondary server so the replication was not working...
my mistake
i've just figure out that i forgot to upgrade the secondary server so the replication was not working...
my mistake
...
@oldsysops Upgrade the OS or PG on the replica?
...
@oldsysops OK, I thought we could run pg_upgrade on the replica for a second but it's not possible so I guess it's the OS
1 ★ 0 ↺
@jriou@hachyderm.io the os, i've done an upgrade to debian 13, switch to the upgraded secondary and the replication log was all about collation mismatch...
but that's ok now, everything is up to date now and replication is on.
i can rest now 🙂
but that's ok now, everything is up to date now and replication is on.
i can rest now 🙂