postGIS install on AWS linux AMI

install-postgis.sh

#!/bin/bash
#
# Script to setup a Elastic Beanstalk AMI with geospatial libraries and postGIS
#
# sh aws_ami_prep.sh > aws_ami_prep.log 2>&1 &

# Go to ec2-user home directory
cd /home/ec2-user

# yum libraries
sudo yum -y install gcc gcc-c++ make cmake libtool libcurl-devel libxml2-devel rubygems swig fcgi-devel\
                    libtiff-devel freetype-devel curl-devel libpng-devel giflib-devel libjpeg-devel\
                    cairo-devel freetype-devel readline-devel openssl-devel python27 python27-devel

# Postgres
wget  http://ftp.postgresql.org/pub/source/v9.3.3/postgresql-9.3.3.tar.gz
tar -zxvf postgresql-9.3.3.tar.gz
cd postgresql-9.3.3
./configure  --with-openssl --bindir=/usr/bin
make
sudo make install
cd ..

# PROJ
wget http://download.osgeo.org/proj/proj-4.8.0.tar.gz
tar -zxvf proj-4.8.0.tar.gz
cd proj-4.8.0
./configure
make
sudo make install
cd ..

# GEOS
wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2
tar -xvf geos-3.4.2.tar.bz2
cd geos-3.4.2
./configure
make
sudo make install
cd ..

# GDAL
wget http://download.osgeo.org/gdal/1.10.1/gdal-1.10.1.tar.gz
tar -zxvf gdal-1.10.1.tar.gz
cd gdal-1.10.1
./configure
make
sudo make install
cd ..

# PostGIS
export LD_LIBRARY_PATH=/usr/local/pgsql/lib/:LD_LIBRARY_PATH
wget http://download.osgeo.org/postgis/source/postgis-2.1.0.tar.gz
tar -xvf postgis-2.1.0.tar.gz
cd postgis-2.1.0
./configure
make
sudo make install
cd ..

You sir, rock!

getting this error:

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Thank you, this is very helpful! I followed other's instructions and couldn't get it to work before I tried your solution. Now that I have multiple installs of postgres, I think I'm messing up the postgis. If I start fresh with your instructions, how do I initiate the database? I tried psql -U postgres but does not work. Thanks!

I am using "Amazon Linux 2 AMI" for EC2 instance and followed the steps mentioned in link. I get following error at step at make step while installing "geos-3.4.2.tar.bz2" . "#error "Can not compile without isnan function or macro" . Tried with latest version of geos, but same error . Any one face similar issue ?

I stopped trying this as a solution, too much of a headache. Instead, I am using docker, so easy!

@DharmendraRathor I had the same problem on AWS Linux 2 AMI. No problems with the earlier version of the AMI though

@DharmendraRathor @sklarsa ran into the same error. Found that a previous beta version of GEOS doesn't throw that eror

wget http://download.osgeo.org/geos/geos-3.7.0beta1.tar.bz2
tar -xvf geos-3.7.0beta1.tar.bz2
cd geos-3.7.0beta1/
./configure
make
sudo make install
cd ..
rm -rvf geos-3.7.0beta1.tar.bz2

Hii @SimonRichartz, I'm having a hard time to get postgis working on a ec2 (AMI) machine. is that the only change you made? can I see your script? thanks

What shall I do if I used PostgreSQL13