store-postgresql-backups-in-minio.md

Store PostgreSQL Backups in Minio Server

In this recipe you will learn how to store PostgreSQL backups in Minio Server.

1. Prerequisites

• Install mc from here.
• Install Minio Server from here.
• PostgreSQL official doc.

2. Configuration Steps

Minio server is running using alias m1. Follow Minio client complete guide here for details. PostgreSQL backups are stored in pgsqlbkp directory.

Create a bucket.

mc mb m1/pgsqlbkp
Bucket created successfully ‘m1/pgsqlbkp’.

Continuously mirror local backup to Minio server.

Continuously mirror pgsqlbkp folder recursively to Minio. Read more on mc mirror here

mc mirror --force --remove --watch  pgsqlbkp/ m1/pgsqlbkp