How To Install postgresql-9.6 on Debian 9

In this tutorial we learn how to install postgresql-9.6 on Debian 9. postgresql-9.6 is object-relational SQL database, version 9.6 server

Introduction

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

What is postgresql-9.6

postgresql-9.6 is:

PostgreSQL is a powerful, open source object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

This package provides the database server for PostgreSQL 9.6.

There are three methods to install postgresql-9.6 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 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 using apt-get by running the following command:

sudo apt-get -y install postgresql-9.6

Install postgresql-9.6 Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install postgresql-9.6

Install postgresql-9.6 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 using aptitude by running the following command:

sudo aptitude -y install postgresql-9.6

How To Uninstall postgresql-9.6 on Debian 9

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

sudo apt-get remove postgresql-9.6

Uninstall postgresql-9.6 And Its Dependencies

To uninstall postgresql-9.6 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

Remove postgresql-9.6 Configurations and Data

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

sudo apt-get -y purge postgresql-9.6

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

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

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

Dependencies

postgresql-9.6 have the following dependencies:

References

Summary

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