Package: autopostgresqlbackup
Version: 1.0-7
Severity: important
Tags: patch
Dear Maintainer,
I have autopostgresql set up on a server at my workplace to back up a small
PostgreSQL database to our mail server using the "files" option. However, I
noticed that backups were not running automatically. When I tried to run a
backup manually, I got this message:
Can't stat supp...@gtgi.com: No such file or directory
supp...@gtgi.com: unable to attach file.
Looking at automysqlbackup (which works properly in files mode on the same
machine), I was able to figure out that there was a parameter missing from
the
command line given to mutt. Adding the parameter makes autopostgresqlbackup
work again.
--- autopostgresqlbackup.orig 2015-05-17 07:48:38.000000000 -0400
+++ autopostgresqlbackup 2017-01-11 11:33:39.390144526 -0500
@@ -642,7 +642,7 @@
elif which mutt >/dev/null 2>&1
then
BACKUPFILES=$(echo $BACKUPFILES | sed -e 's# # -a
#g')
- mutt -s "PostgreSQL Backup Log and SQL Files for
$HOST
- $DATE" $BACKUPFILES $MAILADDR < $LOGFILE
+ mutt -s "PostgreSQL Backup Log and SQL Files for
$HOST
- $DATE" $BACKUPFILES -- $MAILADDR < $LOGFILE
else
cat "$LOGFILE" | mail -s "WARNING! - Enable to send
PostgreSQL Backup dumps, no suitable mail client found on $HOST - $DATE"
$MAILADDR
fi
-- System Information:
Debian Release: 8.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages autopostgresqlbackup depends on:
ii bsd-mailx [mailx] 8.1.2-0.20141216cvs-2
ii postgresql-client-common 165+deb8u1
Versions of packages autopostgresqlbackup recommends:
ii mutt 1.5.23-3
ii openssl 1.0.1t-1+deb8u5
autopostgresqlbackup suggests no packages.
-- Configuration Files:
/etc/default/autopostgresqlbackup changed:
SU_USERNAME=postgres
USERNAME=postgres
DBHOST=localhost
DBNAMES="all"
GLOBALS_OBJECTS="postgres_globals"
BACKUPDIR="/var/lib/autopostgresqlbackup"
MAILCONTENT="files"
MAXATTSIZE="4000"
MAILADDR="supp...@gtgi.com"
MDBNAMES="template1 $DBNAMES"
DBEXCLUDE=""
CREATE_DATABASE=yes
SEPDIR=yes
DOWEEKLY=6
COMP=gzip
COMMCOMP=0
LATEST=no
OPT=""
EXT="sql"
PERM=600
ENCRYPTION=no
ENCRYPTION_PUBLIC_KEY="/etc/ssl/certs/autopostgresqlbackup.crt"
ENCRYPTION_CIPHER="aes256"
ENCRYPTION_SUFFIX=".enc"
-- no debconf information
