Problems Restoring BTCPayServer Postgress

[PraiaBitcoin]

Everytime I need to upgrade BtcPayServer is a very risky situation.

1 - First I need to derypt the files control.dat.asc, alldb.dat and btcpay.dat.asc

cd /mnt/hdd/BACKUP
gpg -d control-XXXXXX.tar.asc > control.dat
gpg -d btcpay-XXXXXX.tar.asc > btcpay.dat
gpg -d alldb-XXXXXX.tar.asc > alldb.dat

3 -Then to import the database I'm running this commands.

cat /mnt/hdd/BACKUP/control.dat | docker exec -i $(docker ps -a -q -f "name=postgres_1") psql -U postgres
cat /mnt/hdd/BACKUP/btcpay.dat  | docker exec -i $(docker ps -a -q -f "name=postgres_1") psql -U postgres
cat /mnt/hdd/BACKUP/alldb.dat  | docker exec -i $(docker ps -a -q -f "name=postgres_1") psql -U postgres

**Sometimes to be correctly imported I need to run the database import command two times **

Sometimes old apps display 500 errors, and the only way to fix it is by changing some configurations and saving them again to the error disappears.

Maybe we could create a script to automate the restore.

Thank you