#!/bin/bash
set -e
# Настройки
DB_NAME="texpres"
BACKUP_DIR="/mnt/backup"
DATE=$(date +"%Y%m%d_%H%M%S")
DT_FILE="${BACKUP_DIR}/${DB_NAME}_${DATE}.dt"
LOG_FILE="${BACKUP_DIR}/backup.log"
IBCMD="sudo -u usr1cv8 /opt/1cv8/x86_64/8.3.27.2214/ibcmd"
mkdir -p "$BACKUP_DIR"
echo "[$(date)] Начало выгрузки базы $DB_NAME" >> "$LOG_FILE"
$IBCMD infobase dump \
--user=Администратор \
--password="890" \
--dbms=PostgreSQL \
--db-server=localhost \
--db-user=postgres \
--db-pwd="postgres" \
--db-name="$DB_NAME" \
"$DT_FILE" >> "$LOG_FILE" 2>&1
echo "[$(date)] Выгрузка завершена успешно." >> "$LOG_FILE"
# Сжатие
#gzip "$DT_FILE"
#echo "[$(date)] Архив создан: ${DT_FILE}.gz" >> "$LOG_FILE"
# Удаление архивов старше 30 дней
find "$BACKUP_DIR" -name "*.dt" -mtime +30 -delete