How To Install postfix-pgsql on Debian 9

In this tutorial we learn how to install postfix-pgsql on Debian 9. postfix-pgsql is PostgreSQL map support for Postfix

Introduction

In this tutorial we learn how to install postfix-pgsql on Debian 9.

What is postfix-pgsql

postfix-pgsql is:

Postfix is Wietse Venema’s mail transport agent that started life as an alternative to the widely-used Sendmail program. Postfix attempts to be fast, easy to administer, and secure, while at the same time being sendmail compatible enough to not upset existing users. Thus, the outside has a sendmail-ish flavor, but the inside is completely different.

This provides support for PostgreSQL maps in Postfix. If you plan to use PostgreSQL maps with Postfix, you need this.

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

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

sudo apt-get update

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

sudo apt-get -y install postfix-pgsql

Install postfix-pgsql Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install postfix-pgsql

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

sudo aptitude -y install postfix-pgsql

How To Uninstall postfix-pgsql on Debian 9

To uninstall only the postfix-pgsql package we can use the following command:

sudo apt-get remove postfix-pgsql

Uninstall postfix-pgsql And Its Dependencies

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

sudo apt-get -y autoremove postfix-pgsql

Remove postfix-pgsql Configurations and Data

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

sudo apt-get -y purge postfix-pgsql

Remove postfix-pgsql configuration, data, and all of its dependencies

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

sudo apt-get -y autoremove --purge postfix-pgsql

Dependencies

postfix-pgsql have the following dependencies:

References

Summary

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