AW: Index Corrupted ?

Hi,

maybe running thhe exact same Software in a docker container on your Windows makes sense?

best,

xx

-----Ursprüngliche Nachricht-----
Von: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Gesendet: Freitag, 15. Oktober 2021 10:42
An: Sébastien Boutté <sebastien(dot)boutte(at)smalltox(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Betreff: Re: Index Corrupted ?

On Fri, Oct 15, 2021 at 4:19 PM Sébastien Boutté <sebastien(dot)boutte(at)smalltox(dot)com> 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).