Auto Backup Openshift Database, Full tutorial: http://medyo.github.io/2017/backup-openshift-database/

auto_backup.sh

#!/bin/bash
NOW="$(date +"%Y-%m-%d")"
FILENAME=$OPENSHIFT_APP_NAME.$NOW.backup.sql.gz
DATABASE_PATH=$OPENSHIFT_DATA_DIR/db_backups/$FILENAME

# Create db_backups folder if not existing
cd $OPENSHIFT_DATA_DIR && mkdir -p db_backups && cd db_backups

# Dump the postgresql database (for Mysql database, check the bottom of this page)
/opt/rh/postgresql92/root/usr/bin/pg_dump -h $OPENSHIFT_POSTGRESQL_DB_HOST -p $OPENSHIFT_POSTGRESQL_DB_PORT -F c $OPENSHIFT_APP_NAME > $FILENAME

# Upload the database using dropbox uploader
$OPENSHIFT_DATA_DIR/dropbox_uploader.sh upload $DATABASE_PATH $FILENAME