Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
27 lines (17 sloc) 1.17 KB

PostgreSQL Backup Image (the manual way)

Use the Crunchy Data PostgreSQL Backup Container to easily backup your PostgreSQL Databases inside an APPUiO project:

git clone https://github.com/CrunchyData/crunchy-containers.git
cd examples/openshift/backup-job/

The backup job requires a persistent volume type such as NFS be mounted by the backup container. APPUiO provides the Persistent Volume (PV), so the first step to use the backup container is to create a Persistent Volume Claim (PVC).

oc create -f backup-job-pvc.json

First we need a admin user on the PostgreSQL database to be able to do a WAL backup. Therefore you should edit the deployment config of the database container and add the following env variable:

name: POSTGRESQL_ADMIN_PASSWORD
value: yourPassword

Create the backup job and container:

oc process -f backup-job-nfs.json \
  -v CCP_IMAGE_TAG="1.2.1"\
    DATABASE_HOST="postgres",DATABASE_USER="postgres",\
    DATABASE_PASS="yourPassword",DATABASE_PORT=5432 \
  | oc create -f -

Note, that the BACKUP_PASS value has to be the same password as configured in the postgres deployment description.