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 / makepostgis30branchw64pg12gcc81.sh
Last active Aug 25, 2019
Build PostGIS 3.0 for windows under mingw64 gcc 8.1 PostgreSQL 12
View makepostgis30branchw64pg12gcc81.sh
#these are compiled using mingw64 gcc 8.1 chain
#http://www.bostongis.com/postgisstuff/ming64gcc81.7z
#!/bin/bash
set -e
export GEOS_VER=3.8
#export GDAL_VER=2.3.1
#export PROJ_VER=6.0.0
export GDAL_VER=3.0.1
export PROJ_VER=6.1.1
export SFCGAL_VER=1.3.2
@robe2
robe2 / makepostgis30dependenciesmingw64gcc81.sh
Created Aug 25, 2019
PostGIS 3.0 windows 64-bit dependencies
View makepostgis30dependenciesmingw64gcc81.sh
#these are compiled using mingw64 gcc 8.1 chain
#http://www.bostongis.com/postgisstuff/ming64gcc81.7z
export OS_BUILD=64
export GCC_TYPE=gcc81
PROJECTS=/projects
SOURCES=/sources
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
echo " OS_BUILD = 32|64"
@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 / 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
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 / 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
@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
@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 / buildosm2pgrouting.sh
Last active Aug 29, 2015
This is for building osm2pgrouting under mingw-w64 chain. Requires all the pgrouting dependencies. https://gist.github.com/robe2/5935101
View buildosm2pgrouting.sh
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
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"
You can’t perform that action at this time.