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="用户"
PGPASSWORD="密码"

# Name of the database to restore
DATABASE_NAME="数据库名"

# Ask user for backup file name
echo -n "Enter the backup file name: "
read BACKUP_FILE

# 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"