copy-db-prod-to-test: Fix problems related to the prod-to-test db copy

copy-db-prod-to-test: Explicitly drop and recreate db on restore Instead of using '--clean' flag for pg_restore, explicitly drop and recreate the database before restoring the dump.

copy-db-prod-to-test: Stop and restart container during db restore To close open sessions to the database, first stop the application container before performing pg_restore. Then restart it afterwards.

JIRA INFRA-8163

requested review from @imretoth and @simonrose

assigned to @andersharrisson

@andersharrisson there is no Approval button for me, but modification seems ok for me:

mentioned in commit 25142600

merged