ERROR: relation "assetindexdata_id_seq" already exists on new database
Not sure how the database backup was created and what's being used to restore it, but using this would fix the error:

CREATE SEQUENCE IF NOT EXISTS 'public.assetindexdata_id_seq'


Alternatively, if you delete the database to destroy all of the associated metadata, then it shouldn't matter.

https://www.postgresql.org/docs/9.5/sql-createsequence.html