Migration script fails on relationships

[tim9009]

Bug report

Required System information

• Node.js version: v18.18.0
• NPM version: 9.8.1
• Source Strapi version: v3.6.5
• Target Strapi version: v4
• Source Database: postgresql
• Target Database: postgresql
• Operating system: MacOS
• Which script are you running: v3-sql-v4-sql

Describe the bug

When running the migration script the script exits with an error every time it is about to migrate a table that includes an id, for example: Key (page_id)=(9) is not present in table "pages".. When looking at the rows in the pages table of the source database I can confirm that the page with id 9 does exist.

Screenshots

[lukaszewczak]

@tim9009 I had the same issue, but I didn't notice the first message in the console Error setting session_replication_role to replica, you may get foreign key constraint errors. After running migration with users who have correct permissions migration works.

[tim9009]

Thank you for pointing that out @lukaszewczak! I ran the migration as a superuser and that allowed the script to finish with no errors 🎉

[derrickmehaffy]

Will close this one as solved :)