39 lines
1000 B
Batchfile
39 lines
1000 B
Batchfile
@echo off
|
|
REM Quick script to add supplementary indexes to jellyfin_testsdata
|
|
|
|
echo ========================================
|
|
echo Add Supplementary Indexes
|
|
echo ========================================
|
|
echo.
|
|
|
|
echo Connecting to jellyfin_testsdata database...
|
|
echo.
|
|
|
|
REM Apply the indexes
|
|
"C:\Program Files\PostgreSQL\18\bin\psql.exe" -U jellyfin -d jellyfin -f sql\schema_init\10_create_supplementary_indexes.sql
|
|
|
|
if %ERRORLEVEL% EQU 0 (
|
|
echo.
|
|
echo ========================================
|
|
echo Success! Indexes added.
|
|
echo ========================================
|
|
echo.
|
|
echo Next steps:
|
|
echo 1. Restart Jellyfin
|
|
echo 2. Monitor performance
|
|
echo.
|
|
) else (
|
|
echo.
|
|
echo ========================================
|
|
echo Failed to add indexes
|
|
echo ========================================
|
|
echo.
|
|
echo Troubleshooting:
|
|
echo - Ensure PostgreSQL is running
|
|
echo - Check database name is correct
|
|
echo - Verify credentials
|
|
echo.
|
|
)
|
|
|
|
pause
|