Set up Python 3 + PostgreSQL 9.6 client dev environment in Ubuntu 14.04. Includes packages 'python3', 'python3-dev', 'postgresql-client-9.6', 'libpq-dev' and latest 'pip' with 'ipython' and 'psycopg2'.

ubuntu-14.04-setup-python-postgres-9.6.sh

#!/usr/bin/env bash

########################################################################
# Setup PostgreSQL+Python 3 client development environment
########################################################################

cd
set -e

echo "Setting up PostgreSQL APT repository..."
wget -q -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list

echo "Refreshing and upgrading packages..."
sudo apt-get update
sudo apt-get upgrade -y
sudo apt-get dist-upgrade -y

echo "Installing packages..."
sudo apt-get install -y \
	build-essential \
	libpq-dev \
	postgresql-client-9.6 \
	python3 \
	python3-dev \

echo "Installing pip..."
wget -q -O - https://bootstrap.pypa.io/get-pip.py | sudo python3

echo "Installing Python requirements..."
sudo pip3 install \
	ipython \
	psycopg2 \