Description of problem:Trying to restore local backup to HA db fails through appliance_console with 'Restore Failed', however running the same restore using 'pg_restore' works fine with no errors.


Version-Release number of selected component (if applicable):5.7.1.0


How reproducible:100%


Steps to Reproduce:
1.Setup HA env following [0]
2.Add provider
3.Backup db (pg_dump was my method)
4.Stop evm service to close connections to db
5.dropdb
6.createdb
7.launch appliance_console
8.select option 7 for restore

Actual results:Restore Fails


Expected results:Restore completes successfully


Additional info:
[0] https://access.redhat.com/documentation/en/red-hat-cloudforms/4.2/single/configuring-high-availability/

On a side note, to drop the db I had to stop/start rh-postgresql95-postgresql as it still had a connection open to the db. This could of been what was causing appliance_console restore to fail, whereas pg_restore could of just been ignoring this connection.