[Postgres migration] pg_partman ExtensionsValidation error

Question

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?

Answer 1

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.