Created
July 16, 2013 17:26
-
-
Save joelkallman/6010748 to your computer and use it in GitHub Desktop.
PostgreSQL Configuration File
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
############################## | |
## POSTGRESQL BACKUP CONFIG ## | |
############################## | |
# Optional system user to run backups as. If the user the script is running as doesn't match this | |
# the script terminates. Leave blank to skip check. | |
BACKUP_USER= | |
# Optional hostname to adhere to pg_hba policies. Will default to "localhost" if none specified. | |
HOSTNAME= | |
# Optional username to connect to database as. Will default to "postgres" if none specified. | |
USERNAME= | |
# This dir will be created if it doesn't exist. This must be writable by the user the script is | |
# running as. | |
BACKUP_DIR=/home/backups/database/postgresql/ | |
# List of strings to match against in database name, separated by space or comma, for which we only | |
# wish to keep a backup of the schema, not the data. Any database names which contain any of these | |
# values will be considered candidates. (e.g. "system_log" will match "dev_system_log_2010-01") | |
SCHEMA_ONLY_LIST="" | |
# Will produce a custom-format backup if set to "yes" | |
ENABLE_CUSTOM_BACKUPS=yes | |
# Will produce a gzipped plain-format backup if set to "yes" | |
ENABLE_PLAIN_BACKUPS=yes | |
#### SETTINGS FOR ROTATED BACKUPS #### | |
# Which day to take the weekly backup from (1-7 = Monday-Sunday) | |
DAY_OF_WEEK_TO_KEEP=5 | |
# Number of days to keep daily backups | |
DAYS_TO_KEEP=7 | |
# How many weeks to keep weekly backups | |
WEEKS_TO_KEEP=5 | |
###################################### |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment