Running manage.py migrate fails when old db imported to new host - null value in column "id" violates not-null constraint

Migrating a previous PSONO server to a new host. I exported the psono db from the old host to a .sql file.

On the new server, i dropped the existing psono db with the following command in psql: drop database psono; then, created the db: create database psono;

I then imported the db dump from the old server: psql psono < psono.sql

When running manage.py migrate, I get the following error (I have attached a screenshot, I cant get the markup formatting correct) Greenshot_2020-06-11_15.08.35

Old host: psono-server version on old server: 1.10.0 (Build d1a38af3) Postgres version: 10.12 (Ubuntu Server 18.04)

New host: psono-server version on new host: 1.15.0 (Build 6e60143e) Psotgres version on new host: 9.6.18 (CentOS 7)

This was installed on the hosts using "Developer/Audit mode", so no docker images is in play.

I successfully did the same action approx 3 weeks ago, without these errors, however I dont have the psono version information from that machine.

Regards, Simon

Edited by Simon Utter