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(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWR%3C/text%3E%3C/svg%3E)
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?
Hi
Wolfgang Roese:
Just checking if you had a chance to look at this. if so, can you please update 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.
![](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(249.60000000000002, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
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
@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.
Hi Wolfgang Roese, Thanks for reaching out to Microsoft Q&A. Pls see Geetha's answer to a similar question before. She has mentioned the fix as well, pls go through and let me know if it helped. https://learn.microsoft.com/en-us/answers/questions/1019044/not-able-to-create-extension-pg-stat-statements-in Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.
@Vinodh247-1375 Thanks for your answer! You suggestion did the trick for the pg_stat_statements error, but it didn't solve the pg_buffercache error.
pg_buffercache cannot be selected in the azure.extensions config. How to create this extension?
did this help? I am not sure, but can try if this is something you can relate to your issue. https://learn.microsoft.com/en-us/answers/questions/1432093/pg-buffercache-extension-not-available-in-postgres
Wolfgang Roese Currently pg_buffercache extension is not supported. Please refer this link - https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions Regards, Oury