A tip: Add this service to your docker-compose.yaml of a deployed app/service for daily backups of that app

[hnykda]

I deploy services with separated postgresql databases (I like to have them separated) via docker-compose. To backup them, I found this docker file that does plain old postgres daily backups:

  dbbackups:
    image: 'kartoza/pg-backup:15-3.3'
    volumes:
      - './db-backups:/backups'
    environment:
      - POSTGRES_HOST=postgres
      - POSTGRES_USER=mmuser
      - POSTGRES_PASS=mmuser_password
      - REMOVE_BEFORE=7
      - DUMPPREFIX=mattermost
    restart: on-failure
    depends_on:
      postgres:
        condition: service_healthy

I then backup these service-specific folders with the dumps there e.g. via duplicity:

duplicity backup \
    --include '/data' \
    --full-if-older-than 1W \
    / \
    rclone://gdrive:/Backups/duplicity-backups

[peaklabs-dev]

Why not use the backup function of coolify itself?

[peaklabs-dev]

@Vahor Yes that is correct. I am working on bringing backups support to everything soon.

[hnykda]

Yeah, I haven't seen that tab anywhere (but because I am using docker-compose). That would be very cool 👍 .

[hnykda]

(I also don't have an S3 storage available, but that just minor detail. Would be nice to be able to run e.g. my own script or something on the backup file)

[peaklabs-dev]

@hnykda Ther is a bounty for that, SFTP will also be added in addition to S3. #2389

[Penfu]

@peaklabs-dev Any updates regarding database backups when using Docker Compose?