Entity IDs in postgres

0
When I import a database into my local postgres instance, following the instructions at https://docs.mendix.com/developerportal/operate/restore-backup-locally/, the ID columns for each Entity are defined in postgres as int(8) and display as a 17 or 18-digit number.  I thought that Entity IDs in Mendix are GUIDs, is that correct?  If so, why are the ID columns not defined as the postgres UUID data type?  Is it possible to convert the postgres ID columns to a traditional 128-bit GUID and/or string?  Or is there data loss going on here?
asked
3 answers
0

Are you restoring a backup of the mendix app or are you restoring a non mendix db backup?

answered
0

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?

 

answered
0

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?

 

answered