pgpool_setup command not found

In this troubleshooting guide we learn how to fix pgpool_setup command not found error message

Introduction

When you run more command in linux terminal / console, you get the following error message

pgpool_setup: command not found

or when using sudo you get the following error message

sudo: pgpool_setup: command not found

Solutions to pgpool_setup: command not found

How To Fix pgpool_setup: command not found in Ubuntu / Debian / Kali Linux / Raspbian

In Ubuntu pgpool_setup is provided by pgpool2 package.

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.

To fix this problem, we can install more using the command below.

sudo apt-get -y install pgpool2

This command might take some time to finish depending on your machine internet connection.

You can also use apt command to install pgpool2.

sudo apt -y install pgpool2

Or if you have aptitude installed you can use the following command.

sudo aptitude install pgpool2

Summary

In this tutorial we learn how to fix pgpool_setup command not found error in Ubuntu / Debian / Kali Linux or Raspbian distribution.