Close

2019-12-02

pgLoader, PostgreSQL data loader tool

postgresql

pgloader loads data into PostgreSQL. The official site is https://pgloader.io/

pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today!

Introduction

pgLoader has two modes of operation. It can either load data from files, such as CSV or Fixed-File Format, or migrate a whole database to PostgreSQL.

pgLoader supports several RDBMS solutions as a migration source and fetches information from the catalog tables over a connection to create an equivalent schema in PostgreSQL. This means that you can migrate to PostgreSQL in a single command line!

Supported operations include:

  • Migrate from MySQL to PostgreSQL
  • Migrate from SQLite to PostgreSQL
  • Migrate from MS SQL Server® to PostgreSQL

You can also migrate from database files in the DBF and IXF formats, where pgLoader can automatically inspect the target table format for you in the file headers.

Migrating to PostgreSQL: the White Paper

The White Paper titled “Migrating to PostgreSQL, Tools and Methodology” explains the idea of Continuous Migration. The paper also covers migration projects’ budget decisions and risk mitigation. It’s free and contains all you need to start, including a PostgreSQL Architecture primer!

Looking for pgloader’s documentation? It is now hosted at http://pgloader.readthedocs.io/en/latest/.

It contains a tutorial for the many different source types supported, code samples, simple and complex load files and command line examples, and a full reference of every option available.