PostgreSQL 註冊啟動 及 停用卸載 批處理指令碼,postgresql批處理

來源:互聯網
上載者:User

PostgreSQL 註冊啟動 及 停用卸載 批處理指令碼,postgresql批處理

註冊啟動 pg_install.bat:

echo offset PGSQL_DIR=%~dp0if not "%PGSQL_HOME%"=="" (    if not "%PGSQL_HOME%"=="%PGSQL_DIR%" (        echo PGSQL_HOME=%PGSQL_HOME% != PGSQL_DIR=%PGSQL_DIR%        goto pg_ends    )) else (    set PGSQL_HOME=%PGSQL_DIR%    echo PGSQL_HOME must be set as PGSQL_DIR=%PGSQL_DIR%)set PATH=%PGSQL_HOME%bin;%PGSQL_HOME%lib;%PATH%pg_isready -h localhost 1>nul 2>nul@if "%ERRORLEVEL%" == "0" (    echo PostgreSQL is running.    goto pg_ends)echo "PGSQL_HOME = %PGSQL_HOME%"echo Install and start PostgreSQL server ...@if not exist %PGSQL_HOME%data (mkdir %PGSQL_HOME%data%PGSQL_HOME%bin/initdb --username=root --pgdata=%PGSQL_HOME%data --encoding=UTF8 --locale=chineserem @if not "%ERRORLEVEL%" == "0" (rem There ERRORLEVEL is 2, but successfully initedrem echo PostgreSQL initdb failed.rem goto pg_endsrem )) pg_ctl register --pgdata=%PGSQL_HOME%data -N pgsql_srv -S demandnet start pgsql_srvrem pg_ctl -w startpg_isready -h localhost 1>nul 2>nul@if "%ERRORLEVEL%" == "0" (echo PostgreSQL server started successfully) else (echo Failed to start PostgreSQL server):pg_endscmd /K


 停用卸載 pg_stop.bat:

@echo offecho Stop and uninstall PostgreSQL server ...pg_isready -h localhost 1>nul 2>nul@if "%ERRORLEVEL%" == "0" (    net stop pgsql_srv)pg_ctl unregister -N pgsql_srv@if "%ERRORLEVEL%" == "0" echo Unregister PostgreSQL successfully:my_ends

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.