On Fri, Oct 15, 2021 at 4:19 PM Sébastien Boutté <sebastien.boutte@xxxxxxxxxxxx> wrote: > > Server > CENTOS 7 > > Dev > Windows 10 English > Postgresql 13.4 > Restore via pg_base_backup + wals reintegration standby.signal Your problem is here. You can't use physical between different system unless they have exactly the same collation library, with the same version, and that's clearly not the case between GNU/Linux and Windows. Your indexes on collatable datatypes are pretty much guaranteed to be immediately corrupted. > I've tried to reindex production database but it has not resolved anything. Indeed, only rebuilding all impacted indexes on the dev server will work, or using logical replication (or a pg_dump / pg_restore).
