pgloader

Install PGLoader

PGLoader is a powerful, open-source data loading tool designed to migrate data from various sources into PostgreSQL databases efficiently. It supports multiple input formats, handles data transformations, and can streamline large-scale data migrations with minimal downtime.

Syntax

pgloader

Examples

To Install PGLoader
$ /go/pgloader

After installation, check that it works
$ pgloader --version

To copy a MySQL database to PostgreSQL using PGLoader

To load data from a CSV file into PostgreSQL
$ pgloader source.csv postgresql://user:password@localhost/dbname

To copy a MySQL database to PostgreSQL using PGLoader
$ pgloader mysql://username:password@localhost/source_db postgresql://username:password@localhost/target_db

Related GoPanel commands

mariadb2postgre - Convert SQL File from MariaDB to PostgreSQL

At Your Service

Our team is on hand 24/7 to not only solve technical issues, but to offer the guidance and technical support you need to succeed online. Give us a ring.

+2 01006931666

Chat