<\/p>\n
What you usually use to backup and restore EDB Postgres is BART<\/a> and the container world is no exception to that. Lets see how that works.<\/p>\n My current deployment looks like this: Two pgpool<\/a> containers are serving three database containers which you can also check on the command line:<\/p>\n What we want to do is to backup the database instances or at least one of them. What you need to prepare before deploying the BART container is shared storage between the databases containers and the BART container. The is especially important for the restore case as the restore procedure needs to access the backup which is hosted in the BART container. Notice that this storage configuration has the “Read-Write-Many” attributes: When I initially deployed the database containers I provided exactly these storage claim and volume as a parameter so I have that available in the database containers: This means in any of the database containers I will be able to see the backup volume:<\/p>\n The same storage configuration then needs to be provided to the BART deployment. Here is the yaml file for the BART deployment:<\/p>\n Once that is imported we can deploy the BART container: What I didn’t tell you is that you need to do another step before. As the BART container is supposed to backup all the instances in a project we need to pass the BART configuration file to the container via a configMap. In this setup I only have one instance so the configMap would look like this: Here you would add all the instances you’d need to backup per project. Once the BART container is ready:<\/p>\n … you can connect to it and perform a manual backup:<\/p>\n This backup is now available on the BART container but in addition it is accessible in the database container:<\/p>\n
\n![\"Selection_013\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_013.jpg\")
<\/a><\/p>\n\ndwe@dwe:~$ oc get pods -o wide -L role\nNAME READY STATUS RESTARTS AGE IP NODE ROLE\nedb-as10-0-1-b8lvj 1\/1 Running 0 3m 172.17.0.9 localhost masterdb\nedb-as10-0-1-gj76h 1\/1 Running 0 1m 172.17.0.5 localhost standbydb\nedb-as10-0-1-sb5lt 1\/1 Running 0 2m 172.17.0.4 localhost standbydb\nedb-pgpool-1-qzk5v 1\/1 Running 0 3m 172.17.0.7 localhost queryrouter\nedb-pgpool-1-rvtl6 1\/1 Running 0 3m 172.17.0.6 localhost queryrouter\n<\/pre>\n
\n![\"Selection_030\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_030.jpg\")
<\/a><\/p>\n
\n![\"Selection_031\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_031.jpg\")
<\/a><\/p>\n\ndwe@dwe:~$ oc rsh edb-as10-0-1-b8lvj\nsh-4.2$ ls -la \/edbbackup\/\ntotal 12\ndrwxrwx--- 3 root root 4096 Aug 6 11:49 .\ndrwxr-xr-x 86 root root 4096 Aug 8 14:03 ..\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 edb-bart-1-89k7s\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/\ntotal 16\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 .\ndrwxrwx--- 3 root root 4096 Aug 6 11:49 ..\ndrwxrwxr-x 2 edbuser root 4096 Aug 6 11:49 bart_log\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 pgbackup\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/pgbackup\/\ntotal 12\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 .dwe@dwe:~$ oc rsh edb-as10-0-1-b8lvj\nsh-4.2$ ls -la \/edbbackup\/\ntotal 12\ndrwxrwx--- 3 root root 4096 Aug 6 11:49 .\ndrwxr-xr-x 86 root root 4096 Aug 8 14:03 ..\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 edb-bart-1-89k7s\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/\ntotal 16\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 .\ndrwxrwx--- 3 root root 4096 Aug 6 11:49 ..\ndrwxrwxr-x 2 edbuser root 4096 Aug 6 11:49 bart_log\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 pgbackup\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/pgbackup\/\ntotal 12\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 .\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 ..\ndrwxr-xr-x 4 edbuser root 4096 Aug 6 11:52 edb\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/pgbackup\/edb\/\ntotal 16\ndrwxr-xr-x 4 edbuser root 4096 Aug 6 11:52 .\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 ..\ndrwxr-xr-x 2 edbuser root 4096 Aug 6 11:52 1533556356576\ndrwxr-xr-x 2 edbuser root 4096 Aug 6 11:49 archived_wals\ndrwxrwxr-x 4 edbuser root 4096 Aug 6 11:49 ..\ndrwxr-xr-x 4 edbuser root 4096 Aug 6 11:52 edb\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-89k7s\/pgbackup\/edb\/\ntotal 16\ndrwxr-xr-x 4 edbuser root 4096 Aug 6 11:52 .\ndrwxrwxr-x 3 edbuser root 4096 Aug 6 11:49 ..\ndrwxr-xr-x 2 edbuser root 4096 Aug 6 11:52 1533556356576\ndrwxr-xr-x 2 edbuser root 4096 Aug 6 11:49 archived_wals\n<\/pre>\n
\napiVersion: v1\nkind: Template\nmetadata:\n name: edb-bart\n annotations:\n description: \"Standard EDB Backup And Recovery Tool Deployment Config\"\n tags: \"database,edbas,postgres,postgresql\"\n iconClass: \"icon-postgresql\"\nlabels:\n template: edb-bart\nobjects:\n- apiVersion: v1\n kind: DeploymentConfig\n metadata:\n name: ${DATABASE_NAME}-bart\n spec:\n replicas: 1\n selector:\n name: ${DATABASE_NAME}-bart\n strategy:\n resources: {}\n rollingParams:\n intervalSeconds: 1\n maxSurge: 25%\n maxUnavailable: 25%\n timeoutSeconds: 600\n updatePeriodSeconds: 1\n type: Rolling\n template:\n metadata:\n labels:\n name: ${DATABASE_NAME}-bart\n role: backuptool \n cluster: ${DATABASE_NAME} \n spec:\n containers:\n - env:\n - name: BART_HOST_ADDRESS \n value: ${BART_HOST_ADDRESS}\n - name: DATABASE_NAME \n value: ${DATABASE_NAME}\n - name: PGHOST\n value: \"${DATABASE_NAME}-service\"\n - name: PGPORT\n value: ${PGPORT}\n - name: REPL_USER\n value: repl\n - name: REPL_PASSWORD\n value: postgres\n - name: BART_AUTOMATE_BACKUP \n value: ${BART_AUTOMATE_BACKUP}\n - name: BART_BACKUP_SCHEDULE \n value: \"${BART_BACKUP_SCHEDULE}\"\n - name: BART_NUM_BACKUPS_TO_KEEP \n value: \"${BART_NUM_BACKUPS_TO_KEEP}\"\n - name: BART_COMPRESS_BACKUP \n value: ${BART_COMPRESS_BACKUP}\n - name: POD_NAMESPACE\n valueFrom:\n fieldRef:\n fieldPath: metadata.namespace\n - name: ACCEPT_EULA\n value: ${ACCEPT_EULA}\n volumeMounts:\n - name: ${BACKUP_VOLUME}\n mountPath: \/edbbackup\n - name: edb-bartconf\n mountPath: \/bartconf\n image: localhost:5000\/edb\/edb-bart:2.0\n imagePullPolicy: Always \n name: edb-bart\n volumes:\n - name: ${BACKUP_VOLUME}\n persistentVolumeClaim:\n claimName: ${BACKUP_VOLUME_CLAIM}\n - name: edb-bartconf\n configMap:\n name: ${DATABASE_NAME}-bartconf-vol\n triggers:\n - type: ConfigChange\nparameters:\n- name: BART_HOST_ADDRESS \n displayName: BART Host Address \n description: BART host address (leave localhost for default)\n value: 'localhost'\n required: true\n- name: DATABASE_NAME \n displayName: Database Name \n description: Name of Postgres database (leave edb for default) \n value: 'edb'\n required: true\n- name: PGHOST\n displayName: Database Host\n description: Database Host (leave ${DATABASE_NAME}-service for default)\n value: ${DATABASE_NAME}-service\n required: true\n- name: PGPORT\n displayName: Database Port\n description: Database Port (leave 5444 for default)\n value: '5444'\n required: true\n- name: BACKUP_VOLUME\n displayName: Backup Volume\n description: Backup volume name\n value: 'edb-backup-pv'\n- name: BACKUP_VOLUME_CLAIM\n displayName: Backup Volume Claim\n description: Backup volume claim name\n value: 'edb-backup-pvc'\n- name: BART_AUTOMATE_BACKUP\n displayName: Automate backup operation (leave 'Yes' for default)\n description: Indicates whether backups should be done automatically \n value: 'Yes'\n required: true\n- name: BART_BACKUP_SCHEDULE \n displayName: BART Backup Schedule\n description: Standard cron schedule - min (0 - 59), hour (0 - 23), day of month (1 - 31), month (1 - 12), day of week (0 - 6) (0 to 6 are Sunday to Saturday, or use names; 7 is Sunday, the same as 0) \n value: '0:0:*:*:*' \n required: true\n- name: BART_NUM_BACKUPS_TO_KEEP \n displayName: BART Number of Backups to Keep\n description: How many backups to keep, older backups will be removed as newer backups are added\n value: '2' \n required: true\n- name: BART_COMPRESS_BACKUP\n displayName: Compress backup files (leave 'Yes' for default) \n description: Indicates whether backup files should be compressed \n value: 'Yes'\n required: true\n- name: ACCEPT_EULA\n displayName: Accept end-user license agreement (leave 'Yes' for default)\n description: Indicates whether user accepts the end-user license agreement\n value: 'Yes'\n required: true\n<\/pre>\n
\n![\"Selection_032\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_032.jpg\")
<\/a>
\nNotice that this is actually the same storage configuration as it was used to setup the database containers.
\n![\"Selection_033\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_033.jpg\")
<\/a><\/p>\n
\n![\"Selection_034\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_034.jpg\")
<\/a><\/p>\n\ndwe@dwe:~$ oc get pods\nNAME READY STATUS RESTARTS AGE\nedb-as10-0-1-b8lvj 1\/1 Running 0 17m\nedb-as10-0-1-gj76h 1\/1 Running 0 14m\nedb-as10-0-1-sb5lt 1\/1 Running 0 16m\nedb-bart-1-7cgfv 1\/1 Running 0 19s\nedb-pgpool-1-qzk5v 1\/1 Running 0 17m\nedb-pgpool-1-rvtl6 1\/1 Running 0 17m\n<\/pre>\n
\ndwe@dwe:~$ oc rsh edb-bart-1-7cgfv\nsh-4.2$ bart backup -s edb\nINFO: creating backup for server 'edb'\nINFO: backup identifier: '1533738106320'\n65043\/65043 kB (100%), 1\/1 tablespace\n\nINFO: backup completed successfully\nINFO: backup checksum: 16fba63925ac3e77d474a36496c2a902 of base.tar\nINFO: \nBACKUP DETAILS:\nBACKUP STATUS: active\nBACKUP IDENTIFIER: 1533738106320\nBACKUP NAME: none\nBACKUP PARENT: none\nBACKUP LOCATION: \/edbbackup\/edb-bart-1-7cgfv\/pgbackup\/edb\/1533738106320\nBACKUP SIZE: 63.52 MB\nBACKUP FORMAT: tar\nBACKUP TIMEZONE: UTC\nXLOG METHOD: fetch\nBACKUP CHECKSUM(s): 1\n ChkSum File \n 16fba63925ac3e77d474a36496c2a902 base.tar \n\nTABLESPACE(s): 0\nSTART WAL LOCATION: 000000010000000000000008\nBACKUP METHOD: streamed\nBACKUP FROM: master\nSTART TIME: 2018-08-08 14:21:46 UTC\nSTOP TIME: 2018-08-08 14:21:47 UTC\nTOTAL DURATION: 1 sec(s)\n<\/pre>\n
\ndwe@dwe:~$ oc rsh edb-as10-0-1-b8lvj\nsh-4.2$ ls -la \/edbbackup\/edb-bart-1-7cgfv\/pgbackup\/edb\/1533738106320\/\ntotal 65060\ndrwxr-xr-x 2 edbuser root 4096 Aug 8 14:21 .\ndrwxr-xr-x 4 edbuser root 4096 Aug 8 14:21 ..\n-rwxr-xr-x 1 edbuser root 664 Aug 8 14:21 backupinfo\n-rwxr-xr-x 1 edbuser root 66605568 Aug 8 14:21 base.tar\n<\/pre>\n
![\"Selection_035\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_035.jpg\")
<\/a><\/p>\n