Offline Migration to postgreSQL flexible server failes with extension creation error

Wolfgang Roese 0 Reputation points
2024-01-27T09:39:10.4766667+00:00

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

  • "plpgsql"
  • "pg_stat_statements"
  • "pg_buffercache"
  • "hypopg"

What could be the cause of this error and how to avoid it?

Azure Database Migration service
Azure Database for PostgreSQL
{count} votes

3 answers

Sort by: Most helpful
  1. Aditya Duvuri 5 Reputation points Microsoft Employee
    2024-01-29T12:42:04.9666667+00:00

    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

    1 person found this answer helpful.

  2. Vinodh247 9,071 Reputation points
    2024-01-27T11:34:46.3733333+00:00

    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.


  3. Oury Ba-MSFT 15,116 Reputation points Microsoft Employee
    2024-01-31T18:49:14.53+00:00

    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

    0 comments No comments