How To Install ulogd2-pgsql on Debian 9

In this tutorial we learn how to install ulogd2-pgsql on Debian 9. ulogd2-pgsql is PostgreSQL extension to ulogd

Introduction

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

What is ulogd2-pgsql

ulogd2-pgsql is:

ulogd is an advanced netfilter logging daemon. It can act as a replacement for syslog for logging netfilter ruleset violations (via the NFLOG or ULOG iptables targets), can gather per-connection accounting using NFCT, or gather per-rule accounting using NFACCT. Output can be sent to plain text log files, a variety of SQL database formats, XML files, pcap files, syslog, and many other formats.

This module adds PostgreSQL support to ulogd. If you install this package, you can send netfilter logs or accounting data to a PostgreSQL database.

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

sudo apt-get -y install ulogd2-pgsql

Install ulogd2-pgsql Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install ulogd2-pgsql

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

sudo aptitude -y install ulogd2-pgsql

How To Uninstall ulogd2-pgsql on Debian 9

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

sudo apt-get remove ulogd2-pgsql

Uninstall ulogd2-pgsql And Its Dependencies

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

sudo apt-get -y autoremove ulogd2-pgsql

Remove ulogd2-pgsql Configurations and Data

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

sudo apt-get -y purge ulogd2-pgsql

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

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

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

Dependencies

ulogd2-pgsql have the following dependencies:

References

Summary

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