Smart Map In Python Tutorial Series - Installing and Configuring PostgreSQL and PostGIS - Part 1

Welcome to the Smart Map In Python Tutorial Series. In the previous tutorial we had a look at some basic technical concepts that should give us an idea on the type of application we are building. We also saw a demo of the final GIS application that we will be building piece by piece, from scratch, with fully open source software.


Now in this tutorial we'll be having a look at installing and configuring PostgreSQL and PostGIS. If you want to check out the video view the link below. Remember to Like and Subscribe and hit the Notification button to make sure you're aware of the latest video we will publish.

Smart Map In Python Tutorial Series - Installing PostgreSQL and PostGIS Part 1 (Video)

Bubble plot on open street map

Step 1: Open your Ubuntu Linux Terminal

Press CTRL + ALT + T

Step 2: Switch to root user account

~$ sudo bash

Step 3: Add an apt-repository and key for PostgreSQL

~$ sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main"

~$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Step 4: Update your repositories

~$ sudo apt-get update

Step 5: Install PostgreSQL 9.6

~$ sudo apt-get install postgresql-9.6 

Step 6: Install PostgreSQL Contrib 9.6

~$ sudo apt-get install postgresql-contrib-9.6

Step 7: Verify that PostgreSQL is installed succesfully

~$ psql --version

Step 8: Add a repository for ubuntugis

~$ sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable

Step 9: Update your repositories

~$ sudo apt-get update

Conclusion

That is about all we need to cover for the first part of the PostgreSQL and PostGIS Installation. I hope you will enjoy it and it will add some value to the projects you are currently busy with.

Stay tuned for the next tutorial in the Smart Map Tutorial Series where we will be continuing to install and configure PostgreSQL and PostGIS.