PostGIS installation in Ubuntu 18.04 LTS “Bionic Beaver”

In my recent work, I have completed one project in Laravel application and it was very similar to the food ordering application like Swiggy/Zomato. For the database, I had used PostgreSQL object-relational and installed PostGIS extension.

PostGIS is open source software program that adds support for geographic objects to the PostgreSQL object-relational database.

postgis installation

I heard about the PostgreSQL database but I never used PostGIS extension so it was a new experience for me. When I was developing API for the mobile application, I had to find nearby restaurants, hotels & cinemas based upon user current location(Latitude and Longitude). So I was searching on google for how to store records with latitude & longitude and how to make queries which return records from the database and after doing some research on google, I found that PostGIS extension which helps me in this scenario.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Before we jump to the PostGIS installation part, I am assuming that you have already installed the latest version of PostgreSQL in your system.

Step 1:

Before you can install PostGIS extension, update your list of available packages so the packages from the new repository are added to the list.

sudo apt-get update

Step 2:

Once your sources update, install the PostGIS extension.

sudo apt-get install postgis

Enter Y when prompted to install PostGIS along with its necessary dependencies. Now we can connect to PostgreSQL and integrate PostGIS.

Step 3:

Using the sudo command and switch to the Postgres user:

sudo -i -u postgres

Step 4:

Connect to the PostGISDemo database:

psql -d PostGISDemo

Step 5:

Enable the PostGIS extension on the database:

CREATE EXTENSION postgis;

Step 6:

Ok. Now let’s verify that everything worked correctly. Execute the following command in your terminal screen:

SELECT PostGIS_version();

You’ll get this output:

            postgis_version
---------------------------------------
2.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)

Step 7:

We’re all set. Type the below command

\q

to exit the SQL session and return to your terminal prompt.

Keep visiting for new stuff and give your feedback.

Happy Coding 😉

Author: Manan Patel

Freelancer + Passionate web developer focused on backend and frontend development.

9 thoughts on “PostGIS installation in Ubuntu 18.04 LTS “Bionic Beaver””

  1. I didn’t get a PostGISDemo database created
    psql -d PostGISDemo
    psql: FATAL: database “PostGISDemo” does not exist
    [1]+ Done $PANGPA start

    Ubuntu 18.04 / PostgreSQL 11.2

  2. Gracias, funciona perfecto.
    Ante posibles dudas de usuarios mas novatos en el tema, se debe crear la base de datos llamada “PostGISDemo”.

  3. This won’t work on Ubuntu 19.04, will it? I tried but got “unmet dependencies” errors. I’ll appreciate any help. Thanks.

Leave a Reply