Breaking News: Grepper is joining You.com. Read the official announcement!

cronjob-yaml

Bhushan Auti answered on April 9, 2024 Popularity 3/10 Helpfulness 1/10

answer cronjob-yaml

cronjob-yaml

Comment

apiVersion: batch/v1
kind: CronJob
metadata:
  name: postgresql-backup-cron-job
  namespace: avaloq-offering-x-prod
  labels:
    avaloq.com/app: avaloq-offering-x
    avaloq.com/zone: front-public
    app.kubernetes.io/component: business-service
spec:
  schedule: '0 0 * * 1-5'
  concurrencyPolicy: Allow
  jobTemplate:
    spec:
      template:
        spec:
          volumes:
            - name: database-backup-volume
              persistentVolumeClaim:
                claimName: uploads-data-volume
            - name: postgres-secret-volume
              secret:
                secretName: postgres-secret
                defaultMode: 420
          containers:
            - name: postgresql-backup-job-pod
              image: 'docker-dev.sits.avaloq.net/avaloq/avaloq-postgresql:3.0.1'
              command:
                - bash
                - '-eo'
                - pipefail
                - '-c'
                - >
                  trap "echo Backup failed; exit 0" ERR; 
                  FILENAME=backup-${DATABASE_NAME}-`date +%Y-%m-%d_%H%M%S`; time \
                  (find /database-backup -type f -name "backup-${DATABASE_NAME}-*" \
                  -exec ls -1tr "{}" + | head -n -${DATABASE_BACKUP_KEEP} | xargs rm -fr; \
                  PGPASSWORD="$DATABASE_PASSWORD" pg_dump \
                  --username=$DATABASE_USER --host=$DATABASE_HOST \
                  --port=$DATABASE_PORT ${DATABASE_NAME} -f /database-backup/$FILENAME.dump); \
                  echo ""; echo "Backup successful"; du -h /database-backup/$FILENAME.dump; \
                  echo "to restore the backup to the serviced host use: $ psql \
                  --username=$DATABASE_USER --password --host=$DATABASE_HOST \
                  --port=$DATABASE_PORT postgres < /database-backup/<backupfile> (unpacked)"; \
                  sleep 100; /usr/bin/find /database-backup -name "*.dump" -mtime 1 -exec rm -rf {} \;
              env:
                - name: DATABASE_BACKUP_KEEP
                  value: '5'
                - name: DATABASE_USER
                  value: offeringxdb_admin
                - name: DATABASE_PASSWORD
                  value: admin
                - name: DATABASE_HOST
                  value: postgres-svc
                - name: DATABASE_PORT
                  value: '5432'
                - name: DATABASE_NAME
                  value: offeringxdb
                - name: TZ
                  value: Europe/Zurich
              volumeMounts:
                - name: database-backup-volume
                  mountPath: /database-backup
                - name: postgres-secret-volume
                  readOnly: true
                  mountPath: /postgres-secret
          restartPolicy: OnFailure

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: chat.openai.com

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Apr 09 2024

Bhushan Auti

0 Answers Avg Quality 2/10

cronjob-yaml

Contents

More Related Answers

cronjob-yaml

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.