Backup and Restore across versions I did a backup of a database using pg_basebackup. I need to restore it to another server.
The database version in the source server is 9.2.23. The destination server postgresql version is 12.
Will there be any problems if I restore from the 9.2.23 to 12?
Yes, there will be problems. That won't work.
You have to restore the backup with PostgreSQL 9.2, only then you can upgrade.