autopostgresqlbackup.conf 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. # Username to access the PostgreSQL server e.g. dbuser
  2. USERNAME=postgres
  3. # Password
  4. # create a file $HOME/.pgpass containing a line like this
  5. # hostname:*:*:dbuser:dbpass
  6. # replace hostname with the value of DBHOST and postgres with
  7. # the value of USERNAME
  8. # Host name (or IP address) of PostgreSQL server e.g localhost
  9. DBHOST=localhost
  10. # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
  11. DBNAMES="all"
  12. # Backup directory location e.g /backups
  13. BACKUPDIR="/srv/backups/pgsql_backups"
  14. # Mail setup
  15. # What would you like to be mailed to you?
  16. # - log : send only log file
  17. # - files : send log file and sql files as attachments (see docs)
  18. # - stdout : will simply output the log to the screen if run manually.
  19. MAILCONTENT="stdout"
  20. # Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
  21. MAXATTSIZE="4000"
  22. # Email Address to send mail to? (user@domain.com)
  23. # MAILADDR="root@localhost"
  24. # ============================================================
  25. # === ADVANCED OPTIONS ( Read the doc's below for details )===
  26. #=============================================================
  27. # List of DBBNAMES for Monthly Backups.
  28. MDBNAMES="$DBNAMES"
  29. # List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
  30. DBEXCLUDE=""
  31. # Include CREATE DATABASE in backup?
  32. CREATE_DATABASE=yes
  33. # Separate backup directory and file for each DB? (yes or no)
  34. SEPDIR=yes
  35. # Which day do you want weekly backups? (1 to 7 where 1 is Monday)
  36. DOWEEKLY=6
  37. # Choose Compression type. (gzip or bzip2)
  38. COMP=gzip
  39. # Command to run before backups (uncomment to use)
  40. # PREBACKUP="/etc/pgsql-backup-pre"
  41. # Command run after backups (uncomment to use)
  42. # POSTBACKUP="bash /home/backups/scripts/ftp_pgsql"