Backup of PostgreSQL database fails, if PostgreSQL admin user has password with ampersand sign.
PostgreSQL admin user has password "
ddd&123qwe ", backup will fails with error:
CREATE GROUP "qqq" WITH USER "admin"
DEBUG Bundle producer exit code: 127
TRACE SQL: DROP GROUP "qqq"
WARN 12323546-494c-40e7-8fe7-8790b1da9626 sh: 123qwe: command not found
sh: 123qwe: command not found
Failed to execute backup database
123qwe is part of PostgreSQL admin password.
Backup utility does not support ampersand sign for PostgreSQL admin password.
Change PostgreSQL admin password to password without ampersand sign using command as below:
# plesk bin database-server --update-server localhost:5432 -type postgresql -passwd 'new_password'