how to install pgtap extension in azure postgresql flexible servers

[Niba-nazar]

Hi,

In the Azure PostgreSQL flexible servers, I want to add the pgtap extension. However, I was unable to locate it in 'shared_preload_libraries' or 'azure.extensions'. To verify whether the extension I need is accessible in Azure Flexible Servers, I attempted to submit a support case for the issue. There, I found a query that shows the available Azure Postgresql extensions: "select * from pg_available_extensions;". Version 1.2.0 of pgtap was located there.

So, I tried to create the extension and got the following error. How can I activate the pgtap extension in the Azure portal?

=> CREATE EXTENSION pgtap;
ERROR:  extension "pgtap" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL
HINT:  to see the full allow list of extensions, please run: "show azure.extensions;"

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: ab533e2e-3fb7-6bed-dd07-1cb4de0368ba
• Version Independent ID: 1df8b46e-3491-ac8b-ba15-03bd062b8680
• Content: Extensions - Azure Database for PostgreSQL - Flexible Server
• Content Source: articles/postgresql/flexible-server/concepts-extensions.md
• Service: postgresql
• Sub-service: flexible-server
• GitHub Login: @sunilagarwal
• Microsoft Alias: sunila

[RamanathanChinnappan-MSFT]

@Niba-nazar

It would be great if you could add a link to the documentation you are following for these steps? This would help us redirect the issue to the appropriate team. Thanks!!

[Niba-nazar]

The search term and the URL used are given below: SELECT * FROM pg_available_extensions; https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions

[shaktisingh-msft]

Hi @sunilagarwal,

Could you please look into this request, thanks.

[Niba-nazar]

hi, any updates?

[Niba-nazar]

hi,

Any updates?

Also, does the Azure Postgres flexible server support file_fdw? It was not found under 'server parameters'. However, it is listed in 'pg_available_extensions'.

[markingmyname]

reassign:@varun-dhawan

[nachoalonsoportillo]

Hello @Niba-nazar. Thanks for taking the time to open this issue. Please, check here the list of extensions (and their corresponding versions) that are supported in Flexible Server.

Also, check our section on How to use PostgreSQL extensions in Flexible Server.

If there is some extension you would like us to incorporate in the service and is not there yet, please go to https://aka.ms/PGFeedback, search if somebody asked for it already and vote for it, or create a new idea in that forum so that others can find it and vote for it. We triage those regularly to plan and prioritize work items in our backlog.

[nachoalonsoportillo]

please-close