pgloader: Migrating a table from MySQL/MariaDB to PostgreSQL

pgloader is a helpful tool if you want to migrate tables from MySQL/MariaDB to Postgres. This works with AWS RDS instances too.

Let’s say we need to migrate the user table from MySQL to PostgreSQL. Your pgloader file would look like below.

You can use the below command to start the migration

$ pgload user.load
· pgloader, mysql, rds, postgres, mariadb