Use the built in backup container to backup external database?

[enoch85]

We have been trying Zammad Docker Compose for a few days now and are finally ready to push it to pre-production!

We are using an external PostgreSQL database server and it works great! Question is, would it be possible to use the backup container to backup the external database? I mean, all the variables are there already.

I tried setting the same ENV to the zammad-backup container as zammad-init it boots alright, but it errors out with an error about that it can’t connect to the atlaszammad (databse name) database.

You can find our config here (without the backup part, but it’s the same ENV as zammad-init:

ENV for external PostgrSQL server?

I can answer my own question: For some one else looking for the full answer, this is working (GlusterFS storage backend, PostgreSQL seperate database server, and Traefik proxy): version: '3.7' services: zammad-elasticsearch: environment: - discovery.type=single-node image: ${IMAGE_REPO}:zammad-elasticsearch${VERSION} restart: ${RESTART} volumes: - elasticsearch-data:/usr/share/elasticsearch/data zammad-init: command: ["zammad-init"] environment: …

Any help would be appreciated!

[enoch85]

The error looks like this:

waiting for railsserver to be ready...


20210414230339 - backuping zammad...


tar: removing leading '/' from member names


Password: 


pg_dump: [archiver (db)] connection to database "companynamezammad" failed: fe_sendauth: no password supplied

[MrGeneration]

Our native backup script currently does not support that.
However, the following PR will change this in the future™:

Maintenance: Improve backup and restore handling.