Loading

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.

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 😉

%d bloggers like this: