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
hstore.dll
architecture: i386:x86-64, flags 0x0000013b:
HAS_RELOC, EXEC_P, HAS_DEBUG, HAS_SYMS, HAS_LOCALS, D_PAGED
start address 0x0000000226cf1320
Characteristics 0x2026
executable
line numbers stripped
@robe2
robe2 / makedependenciesw64gcc81.sh
Last active October 2, 2021 16:40
mingwgcc81 dependencies needed for PostGIS 3.1-PostGIS3.2
export OS_BUILD=64
export GCC_TYPE=gcc81
PROJECTS=/projects
SOURCES=/sources
mkdir ${PROJECTS}
mkdir ${SOURCES}
if [[ "${OS_BUILD}" == "" && "$1" == "" ]] ; then
echo "Usage: makedependencies OS_BUILD"
@robe2
robe2 / makecurl_ssl.sh
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
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 / 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 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 / makepostgis30branchw64pg12gcc81.sh
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
#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 August 25, 2019 04:47
PostGIS 3.0 windows 64-bit dependencies
#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 / build_gdal_and_depends.sh
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 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 September 29, 2017 05:42
PostGIS 2.2 - 2.5 dep mingw64 gcc 4.8
#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 / ogr_fdw_depends_build.sh
Last active April 1, 2017 20:24
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/)
#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