Backup OpenShift PostgreSQL Database

backup_postgres.sh

#!/bin/bash
# Backs up the OpenShift PostgreSQL database for this application
# by Skye Book <skye.book@gmail.com>

NOW="$(date +"%Y-%m-%d")"
FILENAME="$OPENSHIFT_DATA_DIR/$OPENSHIFT_APP_NAME.$NOW.backup.sql.gz"
pg_dump $OPENSHIFT_APP_NAME | gzip > $FILENAME

I liked this way of taking backup and not taking the backup of entire app.
Thank you very much for quick 3 lines, really helpful

Hi, I forked thinking we can do pull request but just found we can't actually.
I just added a line to clean old backup files (mtime +30 = 30 days old)

does not work if database is on separate gear.