bat 安装 Postgres 为服务

1. 安装

@echo off
%1 mshta vbscript:CreateObject("Shell.Application").ShellExecute("cmd.exe","/c %~s0 ::","","runas",1)(window.close)&&exit
echo 已获取管理员权限

echo "1. query the service postgreService"
sc query "postgreService" > nul
if errorlevel 1060 (goto postgreServiceNotExist) else goto postgreServiceExist

:postgreServiceExist
echo 服务已安装
net start postgreService
goto exit

:postgreServiceNotExist
set currentPath=%~dp0
set pgPath=%currentPath:~0,-1%

echo "2. modify privilege"
cacls "%pgPath%" /E /T /G "%USERNAME%":F

echo "3. install service postgreService"
"%pgPath%\bin\pg_ctl" register -N postgreService -D "%pgPath%\data\pgdata" -S auto -o "-p 5432"
net start postgreService

:exit
echo 退出
exit

2. 卸载

@echo off
%1 mshta vbscript:CreateObject("Shell.Application").ShellExecute("cmd.exe","/c %~s0 ::","","runas",1)(window.close)&&exit
echo 已获取管理员权限

echo "uninstall service postgreService"
set currentPath=%~dp0
set pgPath=%currentPath:~0,-1%
net stop postgreService
"%pgPath%\bin\pg_ctl" unregister -N postgreService