Backup of PostgreSQL database fails, if PostgreSQL admin user has password with ampersand sign

Created:

2016-11-16 12:47:14 UTC

Modified:

2017-04-24 12:11:47 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Backup of PostgreSQL database fails, if PostgreSQL admin user has password with ampersand sign

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux

Symptoms

Backup of PostgreSQL database fails, if PostgreSQL admin user has password with ampersand sign.

Example:

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

where 123qwe is part of PostgreSQL admin password.

Cause

Backup utility does not support ampersand sign for PostgreSQL admin password.

Resolution

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'
Have more questions? Submit a request
Please sign in to leave a comment.