pgloader

Name: pgloader
Author: Dimitri Fontaine

A command-line data loading and migration tool for PostgreSQL.

By Dimitri Fontaine

Free Open sourceCommand line

Official websitegithub.com

Compare pgloader with another product

Alternatives

pgcopydbpgcopydb is a free, open-source command-line tool for copying PostgreSQL databases between running servers, with parallel transfer and change replay.
pgsyncA command-line tool for syncing data from one PostgreSQL database to another.
pgstreamCommand-line tool that replicates PostgreSQL data and schema changes to databases, Kafka, webhooks, and search targets.
Search Replace DBA PHP script for searching and replacing database content while handling serialized PHP strings.

See all alternatives

About pgloader

pgloader loads data into PostgreSQL from files and other databases, using PostgreSQL's COPY command. It continues loading valid rows when it encounters rejected data and can reformat values during migration.

Version 4 is distributed as a self-contained JAR and requires Java 21 or later. It accepts the same load-file syntax and command-line flags as version 3.

Strengths

Loads data from databases and files into PostgreSQL
Continues loading good rows when other rows are rejected
Can reformat data during migration

Limitations

Version 4 requires Java 21 or later
Loads data into PostgreSQL rather than serving as a general database migration tool

Details

Pricing: FreeThe repository identifies the license as PostgreSQL.
License: PostgreSQL
Developer: Dimitri Fontaine
Platforms: Command line
How it runs: Downloadable app
Best suited for: Database administrators migrating data into PostgreSQL
Categories: CLI tools, Database tools
Last verified: October 8, 2026
Added: October 8, 2026
Provenance: Selected from the Homebrew formula
Sources: github.com/dimitri/pgloader

Report a wrong fact or a dead link on this listing