How to enable postgres_fdw extension

Question

hey there,

Hope you are well.

I'm just wondering if you could help me with the following query?

When I try to enable the postgres_fdw extension on the 'aw-postgres' and 'ak-app-2025' (Azure Database for PostgreSQL flexible server) using the following command under admin rights (azure_pg_admin) the error message seen below pops up:

CREATE EXTENSION IF NOT EXISTS postgres_fdw;

Error Message:

SQL Error [0A000]: ERROR: extension "postgres_fdw" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

Hint: to learn how to allow an extension or see the list of allowed extensions, please refer to https://go.microsoft.com/fwlink/?linkid=2301063

However the extension seems to be available in both databases.

SELECT * FROM pg_available_extensions

Could you please let me know why I can't enable the extension?

Thanks

Answer 1

Hi AK

Thanks for using the Q&A platform.

The error suggests that while postgres_fdw is available, it is not allow-listed by Microsoft for self-installation by customers.

Kindly confirm if the extension is allowed. You can list allowed extensions using:

SELECT * FROM pg_available_extensions WHERE name = 'postgres_fdw';

If it appears but isn't installable, it's not yet allow-listed for your server/region/tier.

Kindly follow the steps to see if you can allowlist the extension: https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions?tabs=allow-extensions-portal

If that doesn't work, you'll need to request that Microsoft allow-list it for your Azure PostgreSQL Flexible Server instance.

Use the following link to raise support with Azure Microsoft support: https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

If the response was helpful, please feel free to mark it as “Accepted Answer” and consider giving it an upvote. This helps others in the community as well.

Regards,

Obinna.