1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
set PGPORT=5432
set PGHOST=localhost
set PGUSER=postgres
set PGPASSWORD=yourpasswordhere
set THEDB=geocoder
set PGBIN=C:\Program Files\PostgreSQL\9.4\bin
set PGCONTRIB=C:\Program Files\PostgreSQL\9.4\share\contrib
"%PGBIN%\psql" -d "%THEDB%" -f "upgrade_geocode.sql"
REM "%PGBIN%\psql" -d "%THEDB%" -c "ALTER EXTENSION postgis_tiger_geocoder UPDATE;"
REM unremark the loader line to update your loader scripts
REM note this wipes out your custom settings in loader_* tables
REM "%PGBIN%\psql" -d "%THEDB%" -f "tiger_loader_2016.sql"
cd regress
REM "%PGBIN%\psql" -d "%THEDB%" -t -f regress.sql
pause
|
