Blog Post

Microsoft Blog for PostgreSQL
3 MIN READ

PostgreSQL: Migrating Large Objects (LOBs) with Parallelism and PIPES

FranciscoPardillo's avatar
FranciscoPardillo
Icon for Microsoft rankMicrosoft
Dec 02, 2025
Why This Approach? Migrating large objects (LOBs) between PostgreSQL servers can be challenging due to size, performance, and complexity. Traditional methods often involve exporting to files and re...
Updated Nov 23, 2025
Version 1.0
bash script
linux
LOB
PostgreSQL
PSQL Shell
muhd_azeem's avatar
muhd_azeem
Copper Contributor
Dec 10, 2025

I completely agree, pgcopydb has proven effective for large datasets and already used in Azure PostgreSQL Single Server to Flexible Server migrations by MS.

That said, if we were to productize/adopt this approach internally, could you share any reference architecture or recommendations that are; Fully based on Azure PaaS components only & Horizontally scalable with Capable of migrating an arbitrary number of databases (sequentially or in parallel)

Thank you!