@echo off
REM define PGBIN and PATH
set PGBIN=%cd%\tmp_install\usr\local\pgsql\bin
set PATH=%PGBIN%;%PATH%

setlocal enabledelayedexpansion

rmdir /S /Q tmpdb
initdb -D tmpdb >initdb.log 2>&1
echo shared_buffers = 1MB>>tmpdb\postgresql.conf

set /a i = 0
:LOOP
set /a i+=1
echo ITERATION %i%

rmdir /S /Q tmpdb_old
xcopy /e /i /q /r tmpdb tmpdb_old\

pg_ctl -D tmpdb_old -l server.log start
echo SELECT concat('CREATE DATABASE db', g) FROM generate_series(1, 10) g \gexec | psql -d postgres
pg_ctl -D tmpdb_old stop

rmdir /S /Q tmpdb_new
xcopy /e /i /q /r tmpdb tmpdb_new\

pg_upgrade --no-sync -r -b "%PGBIN%" -B "%PGBIN%" -d tmpdb_old -D tmpdb_new
if %ERRORLEVEL% NEQ 0 goto ERR
goto LOOP

:ERR
echo ERROR
pause

:EXIT