Same problem happened to me. I moved the postgresql database to separate server and started getting backup error. I found the solution by deleting and reinstalling postgresql in docker on the main server.
cd /var/discourse
./launcher enter app
apt-get remove postgresql-client-common
apt-get update
sudo apt-get install postgresql