check_postgres.bat

@echo off
echo Checking PostgreSQL status...
echo.

REM Check if PostgreSQL service is running
sc query postgresql-x64-15 >nul 2>&1
if %errorlevel% equ 0 (
    sc query postgresql-x64-15 | findstr /C:"RUNNING" >nul
    if %errorlevel% equ 0 (
        echo [OK] PostgreSQL service is running
    ) else (
        echo [STOPPED] PostgreSQL service is not running
        echo.
        echo To start it, run as Administrator:
        echo   net start postgresql-x64-15
    )
) else (
    REM Try other common service names
    sc query postgresql-x64-16 >nul 2>&1
    if %errorlevel% equ 0 (
        sc query postgresql-x64-16 | findstr /C:"RUNNING" >nul
        if %errorlevel% equ 0 (
            echo [OK] PostgreSQL service is running
        ) else (
            echo [STOPPED] PostgreSQL service is not running
        )
    ) else (
        echo [UNKNOWN] Could not find PostgreSQL service
        echo Please check if PostgreSQL is installed
    )
)

echo.
echo Checking connection...
where psql >nul 2>&1
if %errorlevel% equ 0 (
    echo [OK] psql command found
) else (
    echo [WARNING] psql command not found in PATH
    echo Add PostgreSQL bin directory to PATH
)

echo.
pause