How To Install cl-pgloader on Debian 10

Learn how to install cl-pgloader on Debian 10 with this tutorial. cl-pgloader is extract, transform and load data into PostgreSQL

Introduction

In this tutorial we learn how to install cl-pgloader on Debian 10.

What is cl-pgloader

cl-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 cl-pgloader on Debian 10. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install cl-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 cl-pgloader using apt-get by running the following command:

sudo apt-get -y install cl-pgloader

Install cl-pgloader Using apt

Update apt database with apt using the following command.

sudo apt update

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

sudo apt -y install cl-pgloader

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

sudo aptitude -y install cl-pgloader

How To Uninstall cl-pgloader on Debian 10

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

sudo apt-get remove cl-pgloader

Uninstall cl-pgloader And Its Dependencies

To uninstall cl-pgloader and its dependencies that are no longer needed by Debian 10, we can use the command below:

sudo apt-get -y autoremove cl-pgloader

Remove cl-pgloader Configurations and Data

To remove cl-pgloader configuration and data from Debian 10 we can use the following command:

sudo apt-get -y purge cl-pgloader

Remove cl-pgloader configuration, data, and all of its dependencies

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

sudo apt-get -y autoremove --purge cl-pgloader

Dependencies

cl-pgloader have the following dependencies:

References

Summary

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