Skip to content

Latest commit

 

History

History
24 lines (17 loc) · 1.19 KB

README.md

File metadata and controls

24 lines (17 loc) · 1.19 KB
Raw

mcli-database-backup

This is the minio/mc image with some additional database clients, which we need for backups.

  1. Create a configuration for your bucket. mcli config host add deinstapel $S3_ENDPOINT $ACCESS_KEY $SECRET_KEY --api "s3v4"
  2. Create a backup from your database and pipe it into your bucket. pg_dump -U username -d database | mcli pipe deinstapel/bucket/folder/filename.sql

S3 to S3 mirroring

  • Use s3_to_s3.sh as entrypoint
  • Mount a service account with permissions to read configmaps in the namespace into your pod
  • Populate environment for local and remote s3
    • LOCAL_S3_URL - Local S3 server address
    • LOCAL_ACCESS_KEY - Local S3 access key
    • LOCAL_SECRET_KEY - Local S3 secret key
    • vice versa for REMOTE
    • REMOTE_PREFIX - Prefix for the remote backups bucket names.
  • This will e.g. copy from local/bucket to remote/prefix-bucket-s3-backup

Postgresql backup

For running postgresql backup, the used postgresql client version must match the server version. This image currently contains postgresql clients 12-15 (default=12).

To change the postgresql client version, set the environment variable DEFAULT_PG_VERSION accordingly when running this image.