pgloader command not found

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

Introduction

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

pgloader: command not found

or when using sudo you get the following error message

sudo: pgloader: command not found

Solutions to pgloader: command not found

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

In Ubuntu pgloader is provided by pgloader package.

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.

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

sudo apt-get -y install pgloader

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

You can also use apt command to install pgloader.

sudo apt -y install pgloader

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

sudo aptitude install pgloader

Summary

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