Migrate MySQL, SQLite, or CSV data into PostgreSQL with repeatable load files before cutover with pgloader

Move data into PostgreSQL with declarative load files, built-in type conversion, and repeatable migration runs before one-off import scripts become cutover risk.

Prerequisites

pgloader and access to source systems plus a PostgreSQL target

Installation

Use the upstream install or setup path that matches your environment:

• $ docker pull ghcr.io/dimitri/pgloader:latest
• $ docker run --rm -it ghcr.io/dimitri/pgloader:latest pgloader --version

Requirements and caveats from upstream:

• If you're using docker, you can use the latest version built by the CI at

Basic usage or getting-started notes:

• pgloader also implements data reformatting, a typical example of that

• --help -h boolean Show usage and exit.

• --dry-run boolean Only check database connections, don't load anything.

• Source: https://github.com/dimitri/pgloader

• Extracted from upstream docs: https://raw.githubusercontent.com/dimitri/pgloader/HEAD/README.md

Documentation

• https://pgloader.readthedocs.io/en/latest/

Source

• Agent Skill Exchange