Cant create a Backup, PostgreSQL access

Technical assistance
1

Hello,

creating a backup fails.

root@zammad:/opt/zammad/contrib/backup# sudo ./zammad_backup.sh
creating postgresql backup...
pg_dump: error: connection to database "zammad" failed: FATAL: password authentication failed for user "zammad"

Here is the user table from the PostgreSQL DB

zammad@zammad:~$ psql -l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | 
 template0 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 zammad    | zammad   | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | 
(4 rows)

I cannot access the DB with the root user.

root@zammad:/opt/zammad/contrib/backup# psql -l
psql: error: FATAL:  role "root" does not exist
1 Like
2

Has no one an idea¿?

3

The following has helped

4

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.