Offline Migration to postgreSQL flexible server failes with extension creation error

Wolfgang Roese 0 Reputation points

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

    Hi @Wolfgang Roese Are you trying to migrate to PostgreSQL Flexible server 16? Currently pg_buffercache extension is not supported. Please refer this link -

    1 person found this answer helpful.

  2. Vinodh247 9,071 Reputation points

    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. 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

    Wolfgang Roese Currently pg_buffercache extension is not supported. Please refer this link - Regards, Oury

    0 comments No comments