PG_BUFFERCACHE extension not available in PostgreSQL Flexible Server 16

Question

Hello,

I am trying to migrate Azure PostgreSQL 11 Single Server to Azure PosgreSQL 16 Flexible Server using the Single to Flex migration tool. However I face an issue during the migration: the tool is telling me that it can't create the pg_buffercache extension.

I believe it's because I have not allowed the pg_buffercache extension on the Flexible Server. However I actually can't find this extension in the list given by the azure.extension server parameter.

Is the extension not available yet or will it no longer be available ?

Can I work this around by dropping the pg_buffercache extension on my PostgreSQL 11 Single Server and by recreating it manually with my admin user on the PostgreSQL 16 Flexible Server ? As the underlying objects of the extension will not have the same privileges as if it was created by azure_superuser, will it cause any problem ?

Best regards.

Alexandre

Answer 1

Thanks, Alexandre.

I do not see Postgres 16 as listed version on official Microsoft Doc
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#pg_buffercache

However official Postgres website has this as supported version.

I have also created two servers with version 16 in West Europe and East us and I also do not see this particular extension.
For a more in-depth investigation, I would suggest opening a support case and sharing the case number. If you encounter any issues with case opening, please let us know.

Thank you!