01-24-2021, 06:27 PM
There may be database schema changes from 4.5 to 4.8. Did you run the upgrade script for the db?
cd <INSTALL_DIR>/src/bin
python update_db.py -f
That should clear up any differences between 4.5 and 4.8.
Also, make sure that the target database is *completely* empty. Doing that dump will export everything, including database definitions, table definitions and data. If there is anything in the database, then I believe it will try to merge it somehow, with a lot of the SQL statements failing.
Go into the database and make sure there are no project database and the "sthpw" database is also delete. Only the postgresql default databases can be left. Then import the data and then run the update script as detailed above.
cd <INSTALL_DIR>/src/bin
python update_db.py -f
That should clear up any differences between 4.5 and 4.8.
Also, make sure that the target database is *completely* empty. Doing that dump will export everything, including database definitions, table definitions and data. If there is anything in the database, then I believe it will try to merge it somehow, with a lot of the SQL statements failing.
Go into the database and make sure there are no project database and the "sthpw" database is also delete. Only the postgresql default databases can be left. Then import the data and then run the update script as detailed above.