We are moving servers so I am testing restoring a backup on our new server. When I use the restore command with the
.dump file, it runs for a while and then I start seeing errors:
psql:./data/mysource_matrix-2019-04-01_19-27.dump:3772125: ERROR: role “matrix_hipo” does not exist
Any ideas on why this would happen? Should I be running the restore as a certain user?