From: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
To: Julien Rouhaud <rjuju123@gmail.com>
To: Sébastien Boutté <sebastien.boutte@smalltox.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: AW: Index Corrupted ?
Date: Fri, 15 Oct 2021 08:46:22 +0000
Message-ID: <0aa079bc0fe445c6b7924896a18b98b1@MITMB5.helios.med.uni-muenchen.de> (raw)
In-Reply-To: <CAOBaU_bQvaYON=B13Ect1p3h5oEt081NR=gNCwEF18fd6xSOxg@mail.gmail.com>
References: <CAAw7mLEeZ=NYaK8vMqYgyE8zXj60yVWa+fqCJ3kqr92R72JdfQ@mail.gmail.com>
<CAOBaU_bQvaYON=B13Ect1p3h5oEt081NR=gNCwEF18fd6xSOxg@mail.gmail.com>
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@gmail.com>
Gesendet: Freitag, 15. Oktober 2021 10:42
An: Sébastien Boutté <sebastien.boutte@smalltox.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Betreff: Re: Index Corrupted ?
On Fri, Oct 15, 2021 at 4:19 PM Sébastien Boutté <sebastien.boutte@smalltox.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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Anton.Dischner@med.uni-muenchen.de, rjuju123@gmail.com, sebastien.boutte@smalltox.com, pgsql-admin@lists.postgresql.org
Subject: Re: AW: Index Corrupted ?
In-Reply-To: <0aa079bc0fe445c6b7924896a18b98b1@MITMB5.helios.med.uni-muenchen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox