#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 ?
#dba #NotForAFriend
#dba #NotForAFriend
Discussion
Loading...
Post
@oldsysops If it's a physical replica, the database collation is updated on the replica as soon as you update the primary.
@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?
@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 🙂
@oldsysops You should reindex all databases concurrently after a collation refresh
@jriou@hachyderm.io already done !
it was on my check-list.
it was on my check-list.