postgresql with postgis on amazon linux, debian jessie and ubuntu trusty

amazon.sh

# http://stackoverflow.com/questions/27177327/setting-up-django-with-geodjango-support-in-aws-beanstalk-or-ec2-instance
# http://rpmfind.net/linux/rpm2html/search.php?query=lib64jpeg8
# http://rpmfind.net/linux/rpm2html/search.php?query=lib64poppler5

# install postgresql repo
sudo yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-ami201503-95-9.5-3.noarch.rpm

# add priority=1 to perfer this repo over amzn-main
vim /etc/yum.repos.d/pgdg-95-ami201503.repo

# ensure that pgdg95 repo is used
sudo yum install postgresql95-server postgresql95-contrib

# remove priority setting to perfer amzn-main
vim /etc/yum.repos.d/pgdg-95-ami201503.repo

sudo yum --enablerepo=epel install postgis2_95 \
    ftp://rpmfind.net/linux/Mandriva/official/2010.1/x86_64/media/main/updates/lib64poppler5-0.12.4-2.1mdv2010.1.x86_64.rpm \
    ftp://rpmfind.net/linux/mageia/distrib/1/x86_64/media/core/updates/lib64jpeg8-8b-5.1.mga1.x86_64.rpm \
    https://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/geos-3.5.0-1.rhel6.x86_64.rpm

sudo passwd postgres
sudo service postgresql-9.5 initdb
sudo service postgresql-9.5 start
sudo chkconfig postgresql-9.5 on

su postgres
/usr/pgsql-9.5/bin/psql -p 5432

# in psql
CREATE DATABASE gistest;
\connect gistest;
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
SELECT postgis_full_version();
# POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6" LIBJSON="0.11" TOPOLOGY RASTER

debian-jessie.sh

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6 postgis

# create user and database
sudo -u postgres createuser -P <USER>
sudo -u postgres createdb -O <USER> <DATABASE>

sudo su - postgres
psql -p 5432

# in psql
CREATE DATABASE gistest;
\connect gistest;
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
SELECT postgis_full_version();

ubuntu-trusty.sh

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgis postgresql postgresql-contrib php5-pgsql

# create user and database
sudo -u postgres createuser -P <USER>
sudo -u postgres createdb -O <USER> <DATABASE>

# test connection
psql -h localhost -U <USER> <DATABASE>