如何在Windows系統中強制停止Infobright數據庫?

做法如下：

將XXX替換為您的Infobright數據庫目錄路徑，例如：IB_HOME = C：\ Quest \ Foglight \ infobright

infobright database stop bat shell

rem Set Infobright database home directory path.

set IB_HOME=XXX

rem Try to stop IB in fast mode

%IB_HOME%\bin\pg_ctl stop -w -t 30 --pgdata="%IB_HOME%\pg_data" --ibdatadir="%IB_HOME%\ib_data" -s -m fast

rem Try to stop IB in immediate mode

%IB_HOME%\bin\pg_ctl stop -w -t 30 --pgdata="%IB_HOME%\pg_data" --ibdatadir="%IB_HOME%\ib_data" -s -m immediate

rem Checkout the pid in the first line of the %IB_HOME%\pg_data\postmaster.pid file.

if exist %IB_HOME%\pg_data\postmaster.pid set /p IB_PID=<%IB_HOME%\pg_data\postmaster.pid

if exist %IB_HOME%\pg_data\postmaster.pid taskkill /F /PID %IB_PID% /T

rem Kill bhloader-pure.exe process tree if exists.

taskkill /F /IM bhloader-pure.exe /T

rem Kill ibengine.exe process tree if exists.

taskkill /F /IM ibengine.exe /T

rem Delete the pid file if exists.

if exist %IB_HOME%\pg_data\postmaster.pid del %IB_HOME%\pg_data\postmaster.pid

將上下文作為bat文件保存到您的環境中，然後雙擊以運行它。

檢查Console輸出以驗證是否成功。