# Migrating from MySQL to PostgreSQL

DevFeed: [Migrating from MySQL to PostgreSQL](<https://devfeed.tech/articles/migrating-from-mysql-to-postgresql-34514.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/08/migrating-from-mysql-to-postgresql/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-08-08T15:41: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>), [Software](<https://devfeed.tech/topics/software.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Protocol (disambiguation)](<https://devfeed.tech/topics/protocol.md>)

Tags: [concurrent](<https://devfeed.tech/tags/concurrent.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [protocol](<https://devfeed.tech/tags/protocol.md>), [software](<https://devfeed.tech/tags/software.md>)

## AI overview

The article demonstrates an early version of a MySQL-to-PostgreSQL migration tool based on pgloader. It describes importing data, applying type-casting rules, recreating indexes and primary keys, resetting sequences, and streaming data with concurrent threads and the COPY protocol. It also lists planned features and notes the need for production testing.

## Source excerpt

About the only time when I will accept to work with MySQL is when you need help to migrate away from it because you decided to move to PostgreSQL instead. And it's already been too much of a pain really, so after all this time I began consolidating what I know about that topic and am writing a software to help me here. Consider it the MySQL Migration Toolkit.