Are you restoring a backup of the mendix app or are you restoring a non mendix db backup?
If I understand your question correctly, I am not restoring an “app”, I am restoring a backup of the database from my cloud Production environment, that I downloaded from the Developer Portal → MyApp → Backups page, following the instructions at https://docs.mendix.com/developerportal/operate/restore-backup-locally/ which refers to https://docs.mendix.com/developerportal/operate/download-backup/
I am restoring the backup into my local instance of postgreSQL v14, but I *think* the source / cloud version of RDS is postgres v13, would that make a difference?
I restored my cloud database backup into a local postgres v13 instance, and the ID columns for the restored tables are defined as int(8), the same as postgres v14. So my original question still stands, and I am still in need of an answer.
int(8) = 8 bytes
UUID = 128 bits = 16 bytes
Unless I am missing something, the values of the ID columns in the locally-restored postgres database will not have the same values as the ID columns in the Mendix RDS database in the cloud, and must be losing information. Can someone (preferably from Mendix) either confirm this or tell me what I am missing?