Package: autopostgresqlbackup
Version: 2.3-1
Severity: normal
Dear Maintainer,
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation?
Recently the package was upgraded to 2.3-1.
* What exactly did you do (or not do) that was effective (or
ineffective)?
I didn't change my configuration after the upgrade. And even after using the
new configuration, the backups failed when the systemd service was used.
* What was the outcome of this action?
I received an email that the backups failed.
----8<-----
*Errors/Warnings* (below) reported during backup on *juilin.aybara.org:
(socket)*:
| pg_dump: error: could not close output file: Broken pipe
| Running (as user 'postgres' command 'pg_dump 'postgres' --port 5432
--username postgres --create' has failed
| Something went wrong
'/home/backups/pgsql/daily/postgres/postgres_2025-02-21_12h22m.sql.gz' does not
exists (error during dump?)
| pg_dump: error: could not close output file: Broken pipe
| Running (as user 'postgres' command 'pg_dump 'template1' --port 5432
--username postgres --create' has failed
| Something went wrong
'/home/backups/pgsql/daily/template1/template1_2025-02-21_12h22m.sql.gz' does
not exists (error during dump?)
| pg_dump: error: could not write to output file: Broken pipe
| Running (as user 'postgres' command 'pg_dump 'ttrss' --port 5432 --username
postgres --create' has failed
| Something went wrong
'/home/backups/pgsql/daily/ttrss/ttrss_2025-02-21_12h22m.sql.gz' does not exists
(error during dump?)
| Something went wrong
'/home/backups/pgsql/daily/postgres_globals/postgres_globals_2025-02-21_12h22m.s
ql.gz' does not exists (error during dump?)
Full backup log follows:
*info*| AutoPostgreSQLBackup version 2.3
*info*| Homepage: https://github.com/k0lter/autopostgresqlbackup
*info*| Backup of Database Server (postgresql) - juilin.aybara.org: (socket)
*info*| Backup Start: Fri Feb 21 12:22:07 PM CET 2025
*info*| Backup of Database (daily) 'postgres'
*info*| Rotating 14 daily backups...
*error*| pg_dump: error: could not close output file: Broken pipe
*error*| Running (as user 'postgres' command 'pg_dump 'postgres' --port 5432
--username postgres --create' has failed
*error*| Something went wrong
'/home/backups/pgsql/daily/postgres/postgres_2025-02-21_12h22m.sql.gz' does not
exists (error during dump?)
*info*| Backup of Database (daily) 'template1'
*info*| Rotating 14 daily backups...
*error*| pg_dump: error: could not close output file: Broken pipe
*error*| Running (as user 'postgres' command 'pg_dump 'template1' --port 5432
--username postgres --create' has failed
*error*| Something went wrong
'/home/backups/pgsql/daily/template1/template1_2025-02-21_12h22m.sql.gz' does
not exists (error during dump?)
*info*| Backup of Database (daily) 'ttrss'
*info*| Rotating 14 daily backups...
*error*| pg_dump: error: could not write to output file: Broken pipe
*error*| Running (as user 'postgres' command 'pg_dump 'ttrss' --port 5432
--username postgres --create' has failed
*error*| Something went wrong
'/home/backups/pgsql/daily/ttrss/ttrss_2025-02-21_12h22m.sql.gz' does not exists
(error during dump?)
*info*| Backup of Database (daily) 'postgres_globals'
*info*| Rotating 14 daily backups...
*error*| Something went wrong
'/home/backups/pgsql/daily/postgres_globals/postgres_globals_2025-02-21_12h22m.s
ql.gz' does not exists (error during dump?)
*info*| Backup End: Fri Feb 21 12:22:16 PM CET 2025
*info*| Total disk space used for /home/backups/pgsql:
For more information, try to run AutoPostgreSQLBackup in debug mode, see
`autopostgresqlbackup -h`
----8<-----
* What outcome did you expect instead?
Normal working backups for all my postgresql databases.
When I do a manual run of /usr/sbin/autopostgresqlbackup, it does create
backups that I expect.
----8<-----
root@juilin:/home/backups/pgsql# ls -ltr daily/ttrss/
total 859832
-rw------- 1 root root 109707606 Feb 12 06:25
ttrss_2025-02-12_06h25m.Wednesday.sql.gz
-rw------- 1 root root 109782403 Feb 13 06:25
ttrss_2025-02-13_06h25m.Thursday.sql.gz
-rw------- 1 root root 109844040 Feb 14 06:25
ttrss_2025-02-14_06h25m.Friday.sql.gz
-rw------- 1 root root 110039180 Feb 16 06:25
ttrss_2025-02-16_06h25m.Sunday.sql.gz
-rw------- 1 root root 110180948 Feb 17 06:25
ttrss_2025-02-17_06h25m.Monday.sql.gz
-rw------- 1 root root 110248374 Feb 18 06:25
ttrss_2025-02-18_06h25m.Tuesday.sql.gz
-rw------- 1 root root 110312635 Feb 19 08:01 ttrss_2025-02-19_08h00m.sql.gz
-rw------- 1 root root 110314609 Feb 19 08:08 ttrss_2025-02-19_08h07m.sql.gz
root@juilin:/home/backups/pgsql# date; /usr/sbin/autopostgresqlbackup
Fri Feb 21 12:24:17 PM CET 2025
root@juilin:/home/backups/pgsql# ls -ltr daily/ttrss/
total 967776
-rw------- 1 root root 109707606 Feb 12 06:25
ttrss_2025-02-12_06h25m.Wednesday.sql.gz
-rw------- 1 root root 109782403 Feb 13 06:25
ttrss_2025-02-13_06h25m.Thursday.sql.gz
-rw------- 1 root root 109844040 Feb 14 06:25
ttrss_2025-02-14_06h25m.Friday.sql.gz
-rw------- 1 root root 110039180 Feb 16 06:25
ttrss_2025-02-16_06h25m.Sunday.sql.gz
-rw------- 1 root root 110180948 Feb 17 06:25
ttrss_2025-02-17_06h25m.Monday.sql.gz
-rw------- 1 root root 110248374 Feb 18 06:25
ttrss_2025-02-18_06h25m.Tuesday.sql.gz
-rw------- 1 root root 110312635 Feb 19 08:01 ttrss_2025-02-19_08h00m.sql.gz
-rw------- 1 root root 110314609 Feb 19 08:08 ttrss_2025-02-19_08h07m.sql.gz
-rw------- 1 root root 110529170 Feb 21 12:24 ttrss_2025-02-21_12h24m.sql.gz
root@juilin:/home/backups/pgsql#
----8<-----
-- System Information:
Debian Release: trixie/sid
APT prefers testing-debug
APT policy: (500, 'testing-debug'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 6.0.0-2-amd64 (SMP w/4 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_US:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages autopostgresqlbackup depends on:
ii mailutils [mailx] 1:3.17-2+b4
ii postgresql-client-common 273
Versions of packages autopostgresqlbackup recommends:
ii cron [cron-daemon] 3.0pl1-192
ii gpg 2.2.46-1+b1
ii openssl 3.4.0-2
Versions of packages autopostgresqlbackup suggests:
ii bzip2 1.0.8-6
ii xz-utils 5.6.3-1+b1
ii zstd 1.5.6+dfsg-2
-- Configuration Files:
/etc/default/autopostgresqlbackup changed:
SU_USERNAME=postgres
USERNAME=postgres
DBHOST=localhost
DBNAMES="all"
GLOBALS_OBJECTS="postgres_globals"
BACKUPDIR="/home/backups/pgsql"
MAILCONTENT="log"
MAXATTSIZE="4000"
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
