# Automated Setup for pgloader

DevFeed: [Automated Setup for pgloader](<https://devfeed.tech/articles/automated-setup-for-pgloader-34486.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/01/automated-setup-for-pgloader/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-01-17T13:32:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [Python](<https://devfeed.tech/topics/python.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [csv](<https://devfeed.tech/tags/csv.md>), [database](<https://devfeed.tech/tags/database.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [scripts](<https://devfeed.tech/tags/scripts.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This tutorial describes an automated workflow for migrating data from MySQL to PostgreSQL using pgloader and supporting scripts. It covers schema conversion, exporting problematic MySQL data to CSV, filtering rejected records, generating a pgloader configuration, and handling formatting and encoding issues. The source summary notes that the article covers unsupported pgloader 2.x and recommends pgloader 3.x instead.

## Source excerpt

Another day, another migration from MySQL to PostgreSQL... or at least that's how it feels sometimes. This time again I've been using some quite old scripts to help me do the migration. This article is about versions 2.x of pgloader, which are not supported anymore. Consider using pgloader version 3.x instead. You won't need to generate the configuration anymore as pgloader now connects to a live instance of the source database and query its system catalogs for you.