Postgresql problem on moving discourse with rsync

I would try to install with an empty database and restore it after the site is set up.

I think there might be a minor version difference between your version and the new server so it doesn’t work. Another possibility is that you didn’t shut down the old server before copying the files over.