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