How To Install pgpool2 on Debian 9

In this tutorial we learn how to install pgpool2 on Debian 9. pgpool2 is connection pool server and replication proxy for PostgreSQL

Introduction

In this tutorial we learn how to install pgpool2 on Debian 9.

What is pgpool2

pgpool2 is:

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It provides the following features:

  • Connection Pooling
  • Replication
  • Load Balance
  • Limiting Exceeding Connections
  • Parallel Query

pgpool-II talks PostgreSQL’s backend and frontend protocol, and relays a connection between them. Therefore, a database application (frontend) thinks that pgpool-II is the actual PostgreSQL server, and the server (backend) sees pgpool-II as one of its clients. Because pgpool-II is transparent to both the server and the client, an existing database application can be used with pgpool-II almost without a change to its sources.

This is version 3 of pgpool-II, the second generation of pgpool.

There are three methods to install pgpool2 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 pgpool2 Using apt-get

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

sudo apt-get update

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

sudo apt-get -y install pgpool2

Install pgpool2 Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install pgpool2 using apt by running the following command:

sudo apt -y install pgpool2

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

sudo aptitude -y install pgpool2

How To Uninstall pgpool2 on Debian 9

To uninstall only the pgpool2 package we can use the following command:

sudo apt-get remove pgpool2

Uninstall pgpool2 And Its Dependencies

To uninstall pgpool2 and its dependencies that are no longer needed by Debian 9, we can use the command below:

sudo apt-get -y autoremove pgpool2

Remove pgpool2 Configurations and Data

To remove pgpool2 configuration and data from Debian 9 we can use the following command:

sudo apt-get -y purge pgpool2

Remove pgpool2 configuration, data, and all of its dependencies

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

sudo apt-get -y autoremove --purge pgpool2

Dependencies

pgpool2 have the following dependencies:

References

Summary

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