15056332824/pgdump repository overview

wget https://dl.min.io/client/mc/release/linux-amd64/mc

FROM postgres:10.18-alpine
WORKDIR /
ADD ./mc /
RUN /mc config host add s3 http://oss.chengdd.cn:9000 tmV0bG1RauymuH5j sHGvxaxzOrl3hJfhLkoN5AXZsiJlZ6RA --api s3v4
COPY entrypoint.sh /
ENTRYPOINT ["/entrypoint.sh"]

#!/bin/bash
TIME=`date +%Y%m%d%H%M%S`
pg_dump -h ${HOST} -U ${USERNAME} ${DATABASE} > /tmp/${DATABASE}_${TIME}.sql
/mc cp /tmp/${DATABASE}_${TIME}.sql s3/backups/postgresql/${APPLICATION}/${HOST}/

apiVersion: batch/v1beta1
kind: CronJob
metadata:
  name: gitlabhq-production
  namespace: devops
spec:
  jobTemplate:
    spec:
      template:
        spec:
          containers:
            - imagePullPolicy: IfNotPresent
              name: gitlabhq-production
              image: 15056332824/pgdump:10.18
              env:
                - name: HOST
                  value: 127.0.0.1
                - name: PGPASSWORD
                  value: gitlab
                - name: USERNAME
                  value: gitlab
                - name: DATABASE
                  value: gitlabhq_production
                - name: APPLICATION
                  value: gitlab
          restartPolicy: Never
  schedule: 00 23 * * *