I’m curious about this corrupted index question. If you did have a corrupted index, wouldn’t rsync just propagate that bad information to your new instance? Wouldn’t a backup/restore at least detect that something is wrong?
It’s not clear to me how a corrupt index is best fixed - I see PostgreSQL docs say:
If you suspect corruption of an index on a user table, you can simply rebuild that index, or all indexes on the table, using
REINDEX INDEXorREINDEX TABLE.