Skip to content

Instantly share code, notes, and snippets.

Microsoft (R) COFF/PE Dumper Version 14.29.30141.0
Copyright (C) Microsoft Corporation. All rights reserved.
Dump of file hstore.dll
File Type: DLL
Section contains the following imports:
hstore.dll: file format pei-x86-64
architecture: i386:x86-64, flags 0x0000013b:
start address 0x0000000226cf1320
Characteristics 0x2026
line numbers stripped
robe2 /
Last active October 2, 2021 16:40
mingwgcc81 dependencies needed for PostGIS 3.1-PostGIS3.2
export OS_BUILD=64
export GCC_TYPE=gcc81
mkdir ${PROJECTS}
mkdir ${SOURCES}
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
robe2 /
Last active August 25, 2019 05:10
Build PostGIS 3.0 for windows under mingw64 gcc 8.1 PostgreSQL 12
#these are compiled using mingw64 gcc 8.1 chain
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 /
Created August 25, 2019 04:47
PostGIS 3.0 windows 64-bit dependencies
#these are compiled using mingw64 gcc 8.1 chain
export OS_BUILD=64
export GCC_TYPE=gcc81
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
echo " OS_BUILD = 32|64"
robe2 / postgis_client_tools_ubuntu
Last active October 15, 2020 13:58
Building just PostGIS shp2pgsql and raster2pgsql on 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 xenial-pgdg main" >> /etc/apt/sources.list'
wget --quiet -O - | sudo apt-key add -
sudo apt-get update
robe2 /
Last active November 14, 2018 01:03
This script is for building gdal and gdal dependencies under mingw64, needed by both PostGIS and ogr_fdw
#my windows 64-bit build chain described here is available at
#(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 -
#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
robe2 /
Created January 26, 2017 16:22
export PGBIN=/usr/lib/postgresql/9.6/bin
export PGPORT=5432
export PGHOST=localhost
export PGUSER=postgres
export PGPASSWORD=yourpasswordhere
export PGDATABASE=geocoder
robe2 /
Last active October 1, 2021 20:06
Building curl with ssl support under mingw64
export PROJECTS=/projects
export SOURCES=/sources
#build openssl
if true; then
mkdir ssl
cd ssl
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 /
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 (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
# (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