You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

pg_backup.config 1.5KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. ##############################
  2. ## POSTGRESQL BACKUP CONFIG ##
  3. ##############################
  4. # Optional system user to run backups as. If the user the script is running as doesn't match this
  5. # the script terminates. Leave blank to skip check.
  6. BACKUP_USER=
  7. # Optional hostname to adhere to pg_hba policies. Will default to "localhost" if none specified.
  8. HOSTNAME=
  9. # Optional username to connect to database as. Will default to "postgres" if none specified.
  10. USERNAME=
  11. # This dir will be created if it doesn't exist. This must be writable by the user the script is
  12. # running as.
  13. BACKUP_DIR=/var/lib/postgresql/backup/
  14. # List of strings to match against in database name, separated by space or comma, for which we only
  15. # wish to keep a backup of the schema, not the data. Any database names which contain any of these
  16. # values will be considered candidates. (e.g. "system_log" will match "dev_system_log_2010-01")
  17. SCHEMA_ONLY_LIST=""
  18. # Will produce a custom-format backup if set to "yes"
  19. ENABLE_CUSTOM_BACKUPS=yes
  20. # Will produce a gzipped plain-format backup if set to "yes"
  21. ENABLE_PLAIN_BACKUPS=yes
  22. # Will produce gzipped sql file containing the cluster globals, like users and passwords, if set to "yes"
  23. ENABLE_GLOBALS_BACKUPS=yes
  24. #### SETTINGS FOR ROTATED BACKUPS ####
  25. # Which day to take the weekly backup from (1-7 = Monday-Sunday)
  26. DAY_OF_WEEK_TO_KEEP=1-7
  27. # Number of days to keep daily backups
  28. DAYS_TO_KEEP=7
  29. # How many weeks to keep weekly backups
  30. WEEKS_TO_KEEP=10
  31. ######################################