Hi Lars,
Usually the -c
option on the pg_dump
command adds the SQL statements to drop the objects in the existing database in the correct order, so I’m not sure why you are seeing these errors. Just tested restoring over an existing database with the same parameters and it worked without errors.
Did you upgrade the old service to the latest version, before running the backup? If not, then the new database may have a different schema to the old one.
Try dropping and recreating the existing database before running the psql.exe
command to restore. Run the following statements in the PGAdmin4
query tool:
DROP DATABASE ContinuaCI
CREATE DATABASE ContinuaCI