After pg_restore autoIncrements are reset to 0

Asked Sep 26 '19 at 04:08

Active Sep 26 '19 at 04:41

Viewed 44 times

I am using pg_dump/pg_restore to migrate data from one database to another, but some of tables have autoIncrements defined on the ids.

The autoIncrement is defined with:

  .createTable('MyTable', {
    id: {
      allowNull: false,
      autoIncrement: true,
      primaryKey: true,
      type: Sequelize.INTEGER,
    },

When I try to create a new entry to the table using sequelize I get the error "SequelizeUniqueConstraintError: Validation error" as it is trying to set the id using autoIncrement starting at 0, instead of the next unused number. How can I fix this?

edited Sep 26 '19 at 04:41

asked Sep 26 '19 at 04:08

Michael

Can you describe these "autoincrements" in SQL? – Laurenz Albe Sep 26 '19 at 04:35
See accepted answer for https://stackoverflow.com/questions/8745051/postgres-manually-alter-sequence – ElmoVanKielmo Sep 26 '19 at 04:54

After pg_restore autoIncrements are reset to 0

0 Answers0