linux 备份 docker 里的pg脚本

#!/bin/bash

# PostgreSQL Docker container name
CONTAINER_NAME="容器"

# Backup directory on the host
BACKUP_DIR="/usr/local/pgdata"

# PostgreSQL superuser credentials
PGUSER="yonghu"
PGPASSWORD="密码"

# Name of the database to restore
DATABASE_NAME=" "

# Backup file to restore
BACKUP_FILE="$BACKUP_DIR/${DATABASE_NAME}_${DATE}.bak"

# Run psql command inside the Docker container to create a new database
docker exec -it $CONTAINER_NAME psql -U $PGUSER -c "CREATE DATABASE $DATABASE_NAME"

# Run psql command to restore data from the backup file
docker exec -i $CONTAINER_NAME psql -U $PGUSER -d $DATABASE_NAME < $BACKUP_DIR/$BACKUP_FILE

echo "Data restored to $DATABASE_NAME"