Backup OpenShift PostgreSQL Database

backup_postgres.sh

#!/bin/bash
# Backs up the OpenShift PostgreSQL database for this application
# by Skye Book <[email protected]>

# Local
rhc ssh

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

# Local
echo $FILENAME

rhc scp rails4app download /tmp $FILENAME

gunzip # $OPENSHIFT_APP_NAME.$NOW.backup.sql.gz

psql databasename < data_base_dump