27 lines
899 B
Bash
Executable File
27 lines
899 B
Bash
Executable File
#!/usr/bin/env bash
|
||
set -euo pipefail
|
||
|
||
source "$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)/_common.sh"
|
||
|
||
echo "⚠️ 即将重置整个 PostgreSQL 数据库集群 ..."
|
||
if [ "${OS}" = "Darwin" ]; then
|
||
echo "⚠️ macOS 不支持 pg_dropcluster/systemctl，跳过重置"
|
||
exit 0
|
||
fi
|
||
read -r -p "确定要重置数据库集群? 这将删除所有数据! [y/N] " confirm
|
||
if [ "${confirm}" = "y" ] || [ "${confirm}" = "Y" ]; then
|
||
echo ">>> 停止 PostgreSQL 服务 ..."
|
||
sudo systemctl stop postgresql
|
||
echo ">>> 删除数据库集群 16 main ..."
|
||
sudo pg_dropcluster --stop 16 main
|
||
echo ">>> 清理数据目录 ..."
|
||
sudo rm -rf /var/lib/postgresql/16/main
|
||
echo ">>> 清理配置目录 ..."
|
||
sudo rm -rf /etc/postgresql/16/main
|
||
echo ">>> 创建新的数据库集群 ..."
|
||
sudo pg_createcluster 16 main --start
|
||
echo "✓ PostgreSQL 集群重置完成"
|
||
else
|
||
echo "取消重置"
|
||
fi
|