What I would do is follow the Move a Discourse site to another VPS with rsync except don’t copy over the postgres files.
Then do a database-only backup and restore that. You’ll rsync over the backup as well and restore from the command line.
Is this a very old version, I guess? Did the restore appear to complete successfully?