robe2

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

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:

robe2

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

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

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

#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

#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

#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

#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

#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