- Used Zammad version: 5.1.x
- Used Zammad installation type: (source, package, docker-compose, …) source
- Operating system: CentOS Linux release 7.9.2009 (Core)
- Browser + version:
I try to migrate to a new host. At first I got the empty DB password message so i try the zammad_db_user_helper.sh. The empty password message is gone and I got a new error with the postgresql backup. Can anyone help me out.
Try to backup the instance with the backup scripts in /opt/zammad/contrib/backup
Zammad backup started - Di 10. Mai 15:22:06 CEST 2022!
creating file backup…
… as full dump
creating postgresql backup…
pg_dump: unknown option »–dbname«
try »pg_dump --help« for Information.
ERROR(1) - Database credentials are wrong or database server configuration is invalid.
#-> BACKUP WAS NOT SUCCESSFUL
Steps to reproduce the behavior:
start the backup script again
Well that’s odd because it is:
You may want to let us know about your pgsql version. Nobody can help you with that information.
–dbname != -dbname
- character got copied wrong from a website?
Thanks for the fast reply this is the pgsql version
psql (9.2.24, Server 11.15)
You do read release notes and documentation before updating, right?
thanks for thinking along.
This solved my problem.
- Check the installed version(s) of pg_dump:
find / -name pg_dump -type f 2>/dev/null
- My output was:
- There are two versions installed. To update pg_dump with the newer version:
sudo ln -s /usr/pgsql-9.3/bin/pg_dump /usr/bin/pg_dump --force
This will create the symlink to the newer version.