Transfer MariaDB to PostgreSQL

Fast, streaming database-to-database transfer with parallel processing

Source

MariaDB

Complete MariaDB compatibility

FastTransfer

Streaming Engine

Target

PostgreSQL

bulk load

Terminal

FastTransfer.exe `
  --sourceconnectiontype "mysql" `
  --sourceserver "your-source-server" `
  --sourcedatabase "your-source-db" `
  --query "SELECT * FROM your_table" `
  --targetconnectiontype "postgresql" `
  --targetserver "your-target-server" `
  --targetdatabase "your-target-db" `
  --targettable "your_table" `
  --method "Ntile" `
  --distributekeycolumn "id"  `
  --degree 10

Related Pipelines

MariaDB → MariaDB

ClickHouse → PostgreSQL

MariaDB → DuckDB

MariaDB → MySQL

SQL Server → PostgreSQL

MariaDB → Teradata

✨ Key Features

•Direct database-to-database streaming
•Multiple parallelization methods (Ntile, RangeId, DataDriven)
•Zero intermediate storage required
•Minimal memory footprint

🚀 Performance

•Configurable degree of parallelism
•Optimized for large datasets
•Production-grade reliability
•Real-time progress monitoring