123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- # Username to access the PostgreSQL server e.g. dbuser
- 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 PostgreSQL server e.g localhost
- DBHOST=localhost
- # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
- DBNAMES="all"
- # Backup directory location e.g /backups
- BACKUPDIR="/srv/backups/pgsql_backups"
- # Mail setup
- # What would you like to be mailed to you?
- # - log : send only log file
- # - files : send log file and sql files as attachments (see docs)
- # - stdout : will simply output the log to the screen if run manually.
- MAILCONTENT="stdout"
- # Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
- MAXATTSIZE="4000"
- # Email Address to send mail to? (user@domain.com)
- # MAILADDR="root@localhost"
- # ============================================================
- # === ADVANCED OPTIONS ( Read the doc's below for details )===
- #=============================================================
- # List of DBBNAMES for Monthly Backups.
- MDBNAMES="$DBNAMES"
- # List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
- DBEXCLUDE=""
- # Include CREATE DATABASE in backup?
- CREATE_DATABASE=yes
- # Separate backup directory and file for each DB? (yes or no)
- SEPDIR=yes
- # Which day do you want weekly backups? (1 to 7 where 1 is Monday)
- DOWEEKLY=6
- # Choose Compression type. (gzip or bzip2)
- COMP=gzip
- # Command to run before backups (uncomment to use)
- # PREBACKUP="/etc/pgsql-backup-pre"
- # Command run after backups (uncomment to use)
- # POSTBACKUP="bash /home/backups/scripts/ftp_pgsql"
|