[Answer]-Django: trouble with user_id field of UserProfile after migration from MySQL to PostgreSQL

The problem is solved, and it was happening because the auth_user.id sequence had no owner. This fixed it:

ALTER SEQUENCE auth_auth_id_seq OWNED BY auth_auth.id;