1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
#
# autopostgresqlbackup defaut configuration for Debian
#
#
# See: man autopostgresqlbackup
# or https://github.com/k0lter/autopostgresqlbackup/blob/master/Documentation.md
#
# Email ddress to send errors to. If empty errors are displayed on stdout.
MAILADDR="root"
# Send email to MAILADDR only if there are errors
REPORT_ERRORS_ONLY="yes"
# Only while using PostgreSQL DB Engine
SU_USERNAME="postgres"
# Username to access the Database server
USERNAME="postgres"
# PASSWORD
# create a file $HOME/.pgpass containing a line like this
# hostname:*:*:dbuser:dbpass
# replace hostname with the value of DBHOST and postgres with
# the value of USERNAME
# Host name (or IP address) of the Database server.
DBHOST="localhost"
# Port of Database server.
DBPORT=""
# List of database(s) names(s) to backup.
DBNAMES="all"
# List of databases to exclude
DBEXCLUDE=""
# Virtual database name used to dump global objects (users, roles, tablespaces)
GLOBALS_OBJECTS="postgres_globals"
# Backup directory
BACKUPDIR="/var/lib/autopostgresqlbackup"
# Include CREATE DATABASE statement
CREATE_DATABASE="yes"
# Which day do you want weekly backups?
DOWEEKLY=7
# Which day do you want monthly backups?
DOMONTHLY=1
# Backup retention count for daily backups.
BRDAILY=14
# Backup retention count for weekly backups.
BRWEEKLY=5
# Backup retention count for monthly backups.
BRMONTHLY=12
# Compression tool.
COMP="gzip"
# Compression tools options.
COMP_OPTS=
# Backup files extension
EXT="sql"
# Backup files permission
PERM=600
# Minimum size (in bytes) for a dump/file (compressed or not).
MIN_DUMP_SIZE=256
# Enable encryption (asymmetric) with GnuPG.
ENCRYPTION="no"
# Encryption public key (path to the key)
ENCRYPTION_PUBLIC_KEY=
# Suffix for encyrpted files
ENCRYPTION_SUFFIX=".enc"
# Command or script to execute before backups
#PREBACKUP=
# Command or script to execute after backups
#POSTBACKUP=
|
