Skip to content

Instantly share code, notes, and snippets.

Regina Obe robe2

Block or report user

Report or block robe2

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@robe2
robe2 / build_gdal_and_depends.sh
Last active Nov 14, 2018
This script is for building gdal and gdal dependencies under mingw64, needed by both PostGIS and ogr_fdw
View build_gdal_and_depends.sh
#my windows 64-bit build chain described here is available at http://www.bostongis.com/postgisstuff/ming64gcc48.7z
#(with most of these libraries already built)
#My 32-bit chain is much the same except uses gcc 4.8.1, I'll be posting that as well after I clean it up a bit
#Paul's instructions for setting up mingw on 32-bit are pretty close in concept - https://github.com/pramsey/postgis-build-windows
#Although these are built with mingw64 chain, they are designed to work with the EDB VC++ distributions of PostgreSQL
export OS_BUILD=64
export GCC_TYPE=gcc48
PROJECTS=/projects
SOURCES=/sources
@robe2
robe2 / makepostgisdependenciesgcc48.sh
Last active Sep 29, 2017
PostGIS 2.2 - 2.5 dep mingw64 gcc 4.8
View makepostgisdependenciesgcc48.sh
#PostGIS 2.1, 2.2 dep mingw64 gcc 4.8 (4.8.0 or 4.8.1)
# If you are building 32-bit PostgreSQL 9.4 and expect it to work with EDB Win32 builds
# You must use gcc 4.8.1+ and will also need to edit the
# change the postgresql src/templates/win32 to LDFLAGS="-Wl,--allow-multiple-definition"
# this change is not needed for building 64-bit
# (used to build dependeinces included in http://www.bostongis.com/postgisstuff/ming64gcc48.7z, ming32gcc48.7z )
export OS_BUILD=64 #set to 32 if you are using 32-bit chain
export GCC_TYPE=gcc48 #change this to gcc481 if building with 4.8.1
@robe2
robe2 / postgis_client_tools_ubuntu
Last active Sep 1, 2017
Building just PostGIS shp2pgsql and raster2pgsql on Ubuntu
View postgis_client_tools_ubuntu
apt-get update
apt-get install postgresql-client-9.6 postgresql-server-dev-9.6
#if no postgresql found check what version of Ubuntu you are running
lsb_release -a
#mine read xenial 16.04
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt xenial-pgdg main" >> /etc/apt/sources.list'
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
@robe2
robe2 / ogr_fdw_depends_build.sh
Last active Apr 1, 2017
ogr_fdw building dependencies and fdw under mingw64. For this I used mingw64 x86_64-4.8.3-win32-seh-rt_v3-rev1 (http://sourceforge.net/projects/mingw-w64/)
View ogr_fdw_depends_build.sh
#my windows 64-bit build chain described here is available at http://www.bostongis.com/postgisstuff/ming64gcc48.7z
#(with most of these libraries already built)
#My 32-bit chain is much the same except uses gcc 4.8.1, I'll be posting that as well after I clean it up a bit
#Paul's instructions for setting up mingw on 32-bit are pretty close in concept - https://github.com/pramsey/postgis-build-windows
#Although these are built with mingw64 chain, they are designed to work with the EDB VC++ distributions of PostgreSQL
export OS_BUILD=64
export GCC_TYPE=gcc48
PROJECTS=/projects
SOURCES=/sources
@robe2
robe2 / makecurl_ssl.sh
Last active Apr 1, 2017
Building curl with ssl support under mingw64
View makecurl_ssl.sh
export PROJECTS=/projects
export SOURCES=/sources
#build openssl
if true; then
cd ${PROJECTS}
mkdir ssl
cd ssl
cd ${SOURCES}
export PATH="/mingw/bin:/bin"
#Note that both EDB and BigSQL ship ssleasy32.dll, so you'll want to compile with a version of
View tx.sh
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 Oct 23, 2016
Building v8 and plv8 under mingw-w64
View build_v8_plv8.sh
# 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
View makepostgis21.sh
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 Dec 24, 2015
Building PDAL under mingw64: this currently just builds with compress, xml, and postgresql
View buildpdal.sh
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 Jul 12, 2013
Building pagc address standardizer extension under mingw (to be used with postgis_tiger_geocoder extension for pagc_normalize_address function.
View makepagc.sh
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"
You can’t perform that action at this time.