How To Install postgresql-9.6-postgis-2.3 on Debian 9

In this tutorial we learn how to install postgresql-9.6-postgis-2.3 on Debian 9. postgresql-9.6-postgis-2.3 is Geographic objects support for PostgreSQL 9.6

Introduction

In this tutorial we learn how to install postgresql-9.6-postgis-2.3 on Debian 9.

What is postgresql-9.6-postgis-2.3

postgresql-9.6-postgis-2.3 is:

PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS “spatially enables” the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI’s SDE or Oracle’s Spatial extension. PostGIS follows the OpenGIS “Simple Features Specification for SQL”.

This package supports PostgreSQL 9.6.

There are three methods to install postgresql-9.6-postgis-2.3 on Debian 9. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install postgresql-9.6-postgis-2.3 Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install postgresql-9.6-postgis-2.3 using apt-get by running the following command:

sudo apt-get -y install postgresql-9.6-postgis-2.3

Install postgresql-9.6-postgis-2.3 Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install postgresql-9.6-postgis-2.3 using apt by running the following command:

sudo apt -y install postgresql-9.6-postgis-2.3

Install postgresql-9.6-postgis-2.3 Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Debian. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install postgresql-9.6-postgis-2.3 using aptitude by running the following command:

sudo aptitude -y install postgresql-9.6-postgis-2.3

How To Uninstall postgresql-9.6-postgis-2.3 on Debian 9

To uninstall only the postgresql-9.6-postgis-2.3 package we can use the following command:

sudo apt-get remove postgresql-9.6-postgis-2.3

Uninstall postgresql-9.6-postgis-2.3 And Its Dependencies

To uninstall postgresql-9.6-postgis-2.3 and its dependencies that are no longer needed by Debian 9, we can use the command below:

sudo apt-get -y autoremove postgresql-9.6-postgis-2.3

Remove postgresql-9.6-postgis-2.3 Configurations and Data

To remove postgresql-9.6-postgis-2.3 configuration and data from Debian 9 we can use the following command:

sudo apt-get -y purge postgresql-9.6-postgis-2.3

Remove postgresql-9.6-postgis-2.3 configuration, data, and all of its dependencies

We can use the following command to remove postgresql-9.6-postgis-2.3 configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge postgresql-9.6-postgis-2.3

Dependencies

postgresql-9.6-postgis-2.3 have the following dependencies:

References

Summary

In this tutorial we learn how to install postgresql-9.6-postgis-2.3 package on Debian 9 using different package management tools: apt, apt-get and aptitude.