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 / 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 / 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 / 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 / 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 / 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 / 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