Package: orthanc-postgresql Version: 2.0-2 Severity: wishlist Tags: patch upstream
Please consider adjusting the attached backup script to be installed in /usr/sbin/ and used by, say, cron. It needs a Depends: xz-utils, tar, postgresql-client-common Karsten -- System Information: Debian Release: stretch/sid APT prefers testing APT policy: (990, 'testing'), (500, 'stable-updates'), (500, 'unstable'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 4.6.0-1-686-pae (SMP w/2 CPU cores) Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages orthanc-postgresql depends on: ii libboost-system1.58.0 1.58.0+dfsg-5.1 ii libc6 2.22-11 ii libgcc1 1:6.1.1-7 ii libjsoncpp1 1.7.2-1 ii libpq5 9.5.3-1 ii libstdc++6 6.1.1-7 ii libuuid1 2.28-5 ii orthanc 1.1.0+dfsg-1 orthanc-postgresql recommends no packages. Versions of packages orthanc-postgresql suggests: ii postgresql 9.5+175 -- Configuration Files: /etc/orthanc/postgresql.json changed [not included] -- no debconf information
#!/bin/sh BACKUP_DIR="/root/backup/orthanc/" mkdir -p ${BACKUP_DIR} TS=`date +%Y-%m-%d-%H-%M-%S` sudo -u orthanc pg_dump --verbose --blobs --clean --if-exists --create --format=tar --file=/tmp/orthanc-backup.tar --dbname=orthanc_db xz /tmp/orthanc-backup.tar mv /tmp/orthanc-backup.tar.xz ${BACKUP_DIR}/orthanc-backup-${TS}.tar.xz