joelkallman · July 16, 2013 17:26 · Jul 16, 2013
diff --git a/pg_backup.config b/pg_backup.config
@@ -0,0 +1,42 @@
+  ##############################
+  ## 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
+
+  ######################################