Informat Platform Backup Solution

This document describes how to back up core data of the Informat platform, including databases, shared storage files, and remote transfer of backup files.

---

I. Backup Database

The Informat platform uses PostgreSQL database. Regularly back up the following core databases:

1. Back up account database (user/permission related)

/usr/local/pgsql/bin/pg_dump -U postgres db_informat2_account_prd > /backup/db_informat2_account_prd_$(date +%F).sql

2. Back up biz database (business data related)

/usr/local/pgsql/bin/pg_dump -U postgres db_informat2_biz_prd_0 > /backup/db_informat2_biz_prd_0_$(date +%F).sql

Reminder

✅ It is recommended to set up a scheduled task (cron) to execute daily with a date tag for easy tracing and recovery.

II. Transfer Backup Files to Remote Server

To improve data security, it is recommended to synchronize backup files to a remote server.

scp /backup/*.sql user@192.168.1.100:/data/backup/

Please replace the following items with actual values:

• user: Remote server username
• 192.168.1.100: Remote server IP address
• /data/backup/: Remote backup directory path

III. Backup Shared Storage Files (MinIO)

Uploaded files and other resources in Informat are stored in MinIO by default, and its data directory is /data/minio_home.

Local Backup Example:

cp -r /data/minio_home /backup/minio_home_bak_$(date +%F)

IV. Automatic Backup Script and Scheduled Task Example

1. Backup Script Example /opt/scripts/backup_.sh

#!/bin/bash

BACKUP_DIR="/backup"
DATE=$(date +%F)

# Database backup
/usr/local/pgsql/bin/pg_dump -U postgres db_informat2_account_prd > ${BACKUP_DIR}/db_informat2_account_prd_${DATE}.sql
/usr/local/pgsql/bin/pg_dump -U postgres db_informat2_biz_prd_0 > ${BACKUP_DIR}/db_informat2_biz_prd_0_${DATE}.sql

# MinIO file backup
cp -r /data/minio_home ${BACKUP_DIR}/minio_home_bak_$(date +%F)

# Set permissions
chmod 600 ${BACKUP_DIR}/*.sql

2. Add Scheduled Task (using crontab)

crontab -e

Add the following content (execute backup at 2 AM daily):

0 2 * * * /bin/bash /opt/scripts/backup_zhixin.sh >> /var/log/zhixin_backup.log 2>&1