pgloader

pgloader is a data migration tool designed to load data into PostgreSQL from various sources. It automates the process of migrating databases, handling schema transformations and data type conversions. pgloader supports high-speed data loading using PostgreSQL's COPY command and provides detailed logs for monitoring the migration process.

Features

Supports migration from MySQL, SQLite, and CSV files
Automated schema and data type conversion
High-speed data loading using PostgreSQL's COPY command
Error handling with separate logs for rejected data
Command-line interface for scripting and automation
Open-source under the PostgreSQL license

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow pgloader

pgloader Web Site

Other Useful Business Software

Fully Managed MySQL, PostgreSQL, and SQL Server

Automatic backups, patching, replication, and failover. Focus on your app, not your database.

Cloud SQL handles your database ops end to end, so you can focus on your app.

Try Free

Rate This Project

User Reviews

Be the first to post a review of pgloader!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Common Lisp

Related Categories

Common Lisp Database Software

Registered

2025-06-02

Similar Business Software

Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
Google Cloud BigQuery

BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely...

See Software
Google Cloud Platform

Google Cloud is a cloud-based service that allows you to create anything from simple websites to complex applications for businesses of all sizes. New customers get $300 in free credits to run, test, and deploy workloads. All customers can use 25+ products for free, up to monthly usage...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
dbForge Data Compare for PostgreSQL

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. It helps to custom-tailor the detection of data differences between two PostgreSQL tables, establish smart management of inconsistencies and safe deployment of changes. This PostgreSQL diff tool also...

See Software