Database Transfer - Duplicate Key Error

System Information
  • Strapi Version: 3.6.2
  • Operating System: Linux
  • Database: postgresql
  • Node Version: 12.20.1
  • NPM Version: 6.14.10
  • Yarn Version: 1.22.5

A couple of days I tried to transfer the database from Heroku to my local machine. When I exported a dump of the database to make the transfer, it seemed to work fine at first. But, the sequences were not set correctly during the process, and then I tried to change them one by one. When I try to create or update an data entry an error related to duplicate keys shows up. That comes up randomly. For example, I may create successfully a new entry but when I try to update that entry the error pops up. Is there a better solution for transferring the database or a tool for that purpose?

Hello,

Hope you’re well!

I think we might be experiencing the same issue?

Have you had any luck?