How To Install pgloader on Kali Linux

In this tutorial we learn how to install pgloader on Kali Linux. pgloader is extract, transform and load data into PostgreSQL

Introduction

In this tutorial we learn how to install pgloader on Kali Linux.

What is pgloader

pgloader is:

pgloader imports data from different kind of sources and COPY it into PostgreSQL.

The command language is described in the manual page and allows one to describe where to find the data source, its format, and to describe data processing and transformation.

Supported source formats include CSV, fixed width flat files, dBase3 files (DBF), and SQLite and MySQL databases. In most of those formats, pgloader is able to auto-discover the schema and create the tables and the indexes in PostgreSQL. In the MySQL case it’s possible to edit CASTing rules from the pgloader command directly.

There are three methods to install pgloader on Kali Linux. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install pgloader Using apt-get

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

sudo apt-get update

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

sudo apt-get -y install pgloader

Install pgloader Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install pgloader

Install pgloader Using aptitude

If you want to follow this method, you might need to install aptitude on Kali Linux first since aptitude is usually not installed by default on Kali Linux. Update apt database with aptitude using the following command.

sudo aptitude update

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

sudo aptitude -y install pgloader

How To Uninstall pgloader on Kali Linux

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

sudo apt-get remove pgloader

Uninstall pgloader And Its Dependencies

To uninstall pgloader and its dependencies that are no longer needed by Kali Linux, we can use the command below:

sudo apt-get -y autoremove pgloader

Remove pgloader Configurations and Data

To remove pgloader configuration and data from Kali Linux we can use the following command:

sudo apt-get -y purge pgloader

Remove pgloader configuration, data, and all of its dependencies

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

sudo apt-get -y autoremove --purge pgloader

Dependencies

pgloader have the following dependencies:

References

Summary

In this tutorial we learn how to install pgloader package on Kali Linux using different package management tools: apt, apt-get and aptitude.