Postgres Database Backup

Reiner_Nippes · March 9, 2020, 8:24pm

it should be:

docker exec <nextcloud-db-container-name> pg_dump -c -U <nextcloud-db-user> <nextcloud-db> > /.../nextcloud-db.dump

you’ll find a script here:

github.com

ReinerNippes/nextcloud_on_docker/blob/master/roles/prep_backup/templates/backup_nextcloud.sh.j2

#!/bin/bash

export RESTIC_REPOSITORY="{{ restic_repo }}"
export RESTIC_PASSWORD="{{ restic_backup_secret }}"

# abort entire script if any command fails
set -e

# unlock restic to keep automatic backups going
{{ restic_install_path }}/restic unlock --cleanup-cache

# 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' %}

This file has been truncated. show original

hope you can read jinja templates. and you need restic install.