How To Install postgresql-9.6-pgq3 on Debian 9

In this tutorial we learn how to install postgresql-9.6-pgq3 on Debian 9. postgresql-9.6-pgq3 is Skype tools for PostgreSQL replication, londiste and PGQ

Introduction

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

What is postgresql-9.6-pgq3

postgresql-9.6-pgq3 is:

This is the PGQ extension used by Skype replication, londiste. It consists of PL/pgsql, and C code in database.

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

sudo apt-get -y install postgresql-9.6-pgq3

Install postgresql-9.6-pgq3 Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install postgresql-9.6-pgq3

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

sudo aptitude -y install postgresql-9.6-pgq3

How To Uninstall postgresql-9.6-pgq3 on Debian 9

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

sudo apt-get remove postgresql-9.6-pgq3

Uninstall postgresql-9.6-pgq3 And Its Dependencies

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

Remove postgresql-9.6-pgq3 Configurations and Data

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

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

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

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

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

Dependencies

postgresql-9.6-pgq3 have the following dependencies:

References

Summary

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