How to nextcloud with postgres in docker?

Reiner_Nippes · May 9, 2020, 1:30pm

no need to expose the port. just run pg_dump in the container.

ReinerNippes/nextcloud_on_docker/blob/bab3d3b24a83ec87fcfed9ad230e3eb186ee10df/roles/prep_backup/templates/backup_nextcloud.sh.j2#L21


      
          
          # Make sure nextcloud is enabled when we are done
          trap "docker exec -u www-data nextcloud php occ maintenance:mode --off" EXIT
          
          # set nextcloud to maintenance mode
          docker exec -u www-data nextcloud php occ maintenance:mode --on
          
          {% if nextcloud_db_type == 'mysql' %}
          sudo docker exec nextcloud-db mysqldump --single-transaction -h localhost -u {{ nextcloud_db_user }} -p{{ nextcloud_db_passwd }} {{ nextcloud_db_name }} > {{ nextcloud_database_dump_dir }}/db_dump_{{ nextcloud_db_type }}_nextcloud.sql
          {% elif nextcloud_db_type == 'pgsql' %}
          sudo docker exec nextcloud-db pg_dump -c -U {{ nextcloud_db_user }} {{ nextcloud_db_name }} > {{ nextcloud_database_dump_dir }}/db_dump_{{ nextcloud_db_type }}_nextcloud.sql
          {% endif %}
          
          # backup the data dir
          {{ restic_install_path }}/restic backup --verbose {{ nextcloud_base_dir }}
          
          #
          # end maintenance mode
          docker exec -u www-data nextcloud php occ maintenance:mode --off
          
          # delete trap

further explanation here: