rtisma1/postgres2s3 repository overview

⁠postgres2s3

Automatic periodic backups of PostgresSQL to S3

⁠Environment Variables

⁠Required

# For more information on cron config, refer to:
# https://docs.oracle.com/cd/E12058_01/doc/doc.1014/e12030/cron_expressions.htm
BACKUP_CRONSCHEDULE
BACKUP_AUTOCREATEBUCKET   
BACKUP_PGDUMPEXEPATH
S3_ACCESSKEY
S3_SECRETKEY
S3_BUCKETNAME
S3_ENDPOINTURL
DB_NAME
DB_HOST
DB_PORT
DB_USER
DB_PASSWORD

⁠Optional

BACKUP_PREFIX

⁠Demo

For more information on the configuration, refer to the backup service in the docker-compose.yml.

⁠Demo Startup

Start up the postgres database, s3 object storage using minio, and the postgres2s3 service

./start.sh

By logging into http://localhost:8085⁠ with accessKey minio and secretKey minio123, the backups can be observed every 10 seconds

⁠Stopping Demo and Cleaning Data

To stop all the services and destroy all object data from minio run the following:

./stop.sh