On Thu, Nov 14, 2019 at 08:26:48AM +0100, Laurenz Albe wrote: > If you have data corruption, you shouldn't use pg_upgrade to upgrade. > pg_dumpall / psql is the way to go. Please refer to this wiki page: https://wiki.postgresql.org/wiki/Corruption If you have a cluster in such a state, you have risks of having a corruption which has spread, and you should not reuse this data folder as-is. You can think of this REINDEX as a short-term solution to retrieve as much of your data as you can so as you can dump it, and then restore it into a safer location. For corruptions with system indexes, you also have the option of using ignore_system_indexes. -- Michael
Attachment:
signature.asc
Description: PGP signature
