pgloader ☆
« Back to VersTracker
Description:
Data loading tool for PostgreSQL
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql migration etl database cli
Install: brew install pgloader
About:
Pgloader is a powerful data loading tool that automates the process of migrating data from various sources into PostgreSQL. It handles data extraction, transformation, and loading (ETL) with a single command, ensuring data integrity and optimal performance. The tool supports complex migrations, including schema creation, index rebuilding, and handling of foreign key constraints.
Key Features:
  • Supports migration from MySQL, SQLite, MS SQL, and CSV files
  • Automatic schema creation and data type conversion
  • Parallel loading for high performance
  • Resumable operations and detailed logging
Use Cases:
  • Migrating an existing MySQL database to PostgreSQL
  • Loading large CSV datasets into a structured PostgreSQL table
  • Automating periodic data imports from external sources
Alternatives:
  • pg_dump / pg_restore – Native PostgreSQL tools for backup/restore, but not designed for cross-database migration.
  • Apache NiFi – A more complex, enterprise-grade data flow automation tool, whereas Pgloader is a focused CLI utility.
Version History
Detected Version Rev Change Commit
Mar 12, 2026 5:46pm 0 REVISION_ONLY e6ee2f11
Sep 21, 2025 11:16pm 1 VERSION_BUMP 1bd7181f
Sep 11, 2024 8:57am 1 VERSION_BUMP db9bb127
Jul 22, 2024 5:06am 1 VERSION_BUMP 24aa3e31
Jul 21, 2024 7:15pm 1 VERSION_BUMP 81b456ea
Nov 19, 2022 9:43am 0 VERSION_BUMP f14ed195
« Back to VersTracker  |  Browse Packages  |  About