Ah, right. Let’s try this.
Leave the Rails console (type exit), and while still inside the container (./launcher enter app), run:
su postgres -c "reindexdb discourse"
When that finishes without an error, make a fresh backup on the old server and restore that new file. If it shows an error about a specific table, just paste it here.