Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@robe2
robe2 / tx.sh
Created January 26, 2017 16:22
TMPDIR="/gisdata/temp/"
UNZIPTOOL=unzip
WGETTOOL="/usr/bin/wget"
export PGBIN=/usr/lib/postgresql/9.6/bin
export PGPORT=5432
export PGHOST=localhost
export PGUSER=postgres
export PGPASSWORD=yourpasswordhere
export PGDATABASE=geocoder
PSQL=${PGBIN}/psql
@robe2
robe2 / build_v8_plv8.sh
Last active October 23, 2016 23:49
Building v8 and plv8 under mingw-w64
# I still haven't figured out how to build with gyp,
# after many hours trying downloading 700 mb of a toolchain google forces me to use,
# so I still build with a version of v8 that I know works with scons
# 1. install scons (32-bit) from http://www.scons.org/ (I think mine is 2.3.4) and I have in python 2.7 something
# 2. For this I've been using mingw-w64 on a windows 7 64-bit ((x86_64-win32-seh-rev1, Built by MinGW-W64 project) 4.8.3) , Msys
# http://mingw-w64.sourceforge.net/download.php (for the 32-bit version I use minGW-w64 w32 chain ( (rev2, Built by MinGW-W64 project) 4.8.1 with sjlj ) )
##Building V8
## Rest is script, there is some manual edit involved
OS_BUILD=64
export OS_BUILD=64
export PROJECTS=/projects
export GCC_TYPE=gcc48
export PATHOLD=$PATH
export PROJ_VER=4.8.0
#echo $PATHOLD
echo $PATHOLD >c:/path.txt
#export PATHOLD=".:/bin:/mingw/bin:/mingw/include:/c/Windows/system32:/c/Windows:/usr/local/bin"
export export PATHOLD="/mingw/bin:/mingw/include:/c/Windows/system32:/bin:/include" #export PATHOLD=".:/bin:/include:/mingw/bin:/mingw/include:/c/Windows/system32:/c/Windows:/usr/local/bin"
@robe2
robe2 / buildpdal.sh
Last active December 24, 2015 18:59
Building PDAL under mingw64: this currently just builds with compress, xml, and postgresql
export OS_BUILD=64
export GCC_TYPE=gcc48
export SOURCES=/sources
PROJECTS=/projects
export PATHOLD="/mingw/bin:/mingw/include:/c/Windows/system32:/cmake/bin:/bin"
if true; then
export LIBXML_VER=2.7.8
#export LIBLAS_VER=1.7.0
#export PROJ_VER=4.8.0
@robe2
robe2 / makepagc.sh
Created July 12, 2013 03:08
Building pagc address standardizer extension under mingw (to be used with postgis_tiger_geocoder extension for pagc_normalize_address function.
export OS_BUILD=32
export PROJECTS=/projects
export PATHOLD=$PATH
export GCC_TYPE=
export SOURCES=/sources
#echo $PATHOLD
echo $PATHOLD >c:/path.txt
#export PATHOLD=".:/bin:/mingw/bin:/mingw/include:/c/Windows/system32:/c/Windows:/usr/local/bin"
#export PATHOLD=".:/bin:/include:/mingw/bin:/mingw/include:/c/Windows/system32:/c/Windows:/c/Windows/SysWow64"
@robe2
robe2 / makepgRoutingDependencies.sh
Last active December 19, 2015 09:39
pgRouting dependencies mingw64 chain (OS_BUILD toggle between 64 (gcc 4.8.3) and 32 (gcc 4.8.1))
#!/bin/sh
#use 7zip to extract the dev env
# 64-bit builds my chain is http://www.bostongis.com/postgisstuff/ming64gcc48.7z (gcc 4.8.3)
export GCC_TYPE=gcc48
export OS_BUILD=64
export SOURCES=/projects/sources
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
echo " OS_BUILD = 32|64"
echo " or export OS_BUILD=xx"
@robe2
robe2 / makepgRouting.sh
Last active December 19, 2015 03:38
Building pgRouting under mingw64 using non-standard install locations of dependencies
export OS_BUILD=64
export PROJECTS=/projects
export PG_VER=9.4
export GCC_TYPE=gcc48
export PGPATH=${PROJECTS}/postgresql/rel/pg${PG_VER}w${OS_BUILD}${GCC_TYPE}
export PATHOLD=$PATH
echo $PATHOLD >c:/path.txt
@robe2
robe2 / buildpointcloud.sh
Last active December 19, 2015 01:59
Building pointcloud under mingw64gcc48 (http://www.bostongis.com/postgisstuff/ming64gcc48.7z)
export OS_BUILD=64
export GCC_TYPE=gcc48
PROJECTS=/projects
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
echo " OS_BUILD = 32|64"
echo " or export OS_BUILD=xx"
exit 1
fi
@robe2
robe2 / gist:5819062
Last active December 18, 2015 17:29
GEOS 3.4 CMAKE BUILD_TYPE=Release test results using gcc 4.8.1
Running tests...
Test project C:/ming64gcc48/projects/geos/branches/build
Start 1: geos_unit
1/4 Test #1: geos_unit ........................ Passed 0.08 sec
Start 2: xmltester
2/4 Test #2: xmltester ........................ Passed 2.73 sec
Start 3: bug234
3/4 Test #3: bug234 ........................... Passed 0.02 sec
Start 4: TestSweepLineSpeed
4/4 Test #4: TestSweepLineSpeed ............... Passed 0.97 sec
@robe2
robe2 / buildosm2pgrouting.sh
Last active August 29, 2015 14:10
This is for building osm2pgrouting under mingw-w64 chain. Requires all the pgrouting dependencies. https://gist.github.com/robe2/5935101
export OS_BUILD=64
export PROJECTS=/projects
export PG_VER=9.4
export GCC_TYPE=gcc48
export PGPATH=${PROJECTS}/postgresql/rel/pg${PG_VER}w${OS_BUILD}${GCC_TYPE}
GMP_VER=5.1.2
MPFR_VER=3.1.2
CGAL_VER=4.2
#BOOST_VER=1.47.0