This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 4%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
I'm getting the following error:
Error 603405: Unsupported extension(s). The migration service does not support the migration of databases with 'pg_partman' extension(s) on the target server.
And I know we have that error listed here. Is there a workaround for this?
We can't go this way as we need to perform an online migration and also, we need the new data to be replicated in the target database. The DB we are migrating is too heavy > 3 TB
@LuisC Can you provide more details like what is the source here along with the PostgreSQL version? Also, what is pg_partman version?
Regards
Geetha
Yes, the source is Amazon RDS for PostgreSQL, the version is 15.2 and the pg_partman version is the one installed by RDS, 4.6.0 in this case.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi LuisC •,
Welcome to Microsoft Q&A forum.
As I understand, you are performing migration of Azure Database for PostgreSQL and due to pg_partman it is failing.
Could you please try dump and restore method as illustrated here if that suits to your requirement:
Let us know if your ask is different.
Thanks
Hi LuisC •,
As of today, there is no direct workaround for pg_partman extension, only workaround is to use pg_dump and pg_restore or remove that extension from the source DB.
Please feel free to submit your feedback over Azure Database for PostgreSQL Community so that team can acknowledge and work on it depending on the importance and up-votes received.
Thanks.