Hi @Wolfgang Roese Are you trying to migrate to PostgreSQL Flexible server 16? Currently pg_buffercache extension is not supported. Please refer this link - https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions
Offline Migration to postgreSQL flexible server failes with extension creation error
Migrating my PostgreSQL Single Server to Flexible Server does not work. The error message is as follows:
One or more errors occurred while migrating 'xxx' : EX001: Extension creation failed for the following extensions: hypopg, pg_buffercache, pg_stat_statements. Please retry the migration after few minutes. If the error persists please contact Microsoft customer support
I retried several times and also re-created the flexible server two times. The migration validation was green in all cases. Before executing the migration I followed the suggested pre-migration steps mentioned here. The extensions on the single server are
What could be the cause of this error and how to avoid it?
Wolfgang Roese If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sign in to comment