51 lines
951 B
Batchfile
51 lines
951 B
Batchfile
@echo off
|
||
echo PostgreSQL Docker 重置脚本
|
||
echo ===========================
|
||
|
||
echo.
|
||
echo 1. 停止所有相关容器...
|
||
docker-compose down
|
||
|
||
echo.
|
||
echo 2. 删除相关容器（如果存在）...
|
||
docker rm -f mixvideo_postgres mixvideo_pgadmin 2>nul
|
||
|
||
echo.
|
||
echo 3. 删除相关镜像缓存...
|
||
docker system prune -f
|
||
|
||
echo.
|
||
echo 4. 删除数据卷（这会清除所有数据）...
|
||
docker volume rm mixvideo_postgres_data mixvideo_pgadmin_data 2>nul
|
||
|
||
echo.
|
||
echo 5. 重新拉取镜像...
|
||
docker-compose pull
|
||
|
||
echo.
|
||
echo 6. 启动 PostgreSQL 服务...
|
||
docker-compose up -d postgres
|
||
|
||
echo.
|
||
echo 7. 等待服务启动（30秒）...
|
||
timeout /t 30
|
||
|
||
echo.
|
||
echo 8. 检查服务状态...
|
||
docker-compose ps
|
||
|
||
echo.
|
||
echo 9. 查看日志...
|
||
docker-compose logs postgres
|
||
|
||
echo.
|
||
echo 重置完成！
|
||
echo 连接信息：
|
||
echo 主机: localhost
|
||
echo 端口: 5433
|
||
echo 数据库: mixvideo
|
||
echo 用户: mixvideo_user
|
||
echo 密码: mixvideo_password
|
||
echo.
|
||
pause
|