| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Sébastien Boutté <sebastien(dot)boutte(at)smalltox(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Index Corrupted ? |
| Date: | 2021-10-15 08:41:41 |
| Message-ID: | CAOBaU_bQvaYON=B13Ect1p3h5oEt081NR=gNCwEF18fd6xSOxg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dischner, Anton | 2021-10-15 08:46:22 | AW: Index Corrupted ? |
| Previous Message | Sébastien Boutté | 2021-10-15 08:18:58 | Index Corrupted ? |