extension "azure" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

Question

extension "azure" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

Leonard Lindenau 0

Hi,

I am setting up an Azure Database for PostreSQL with timesscaleDB extension and currently working on adding migrations for it on my .Net 7.0 application.

I was able to generate the initial migration based on the database structure I created, but when I try to run the 'Update-Database' command I get the following error:

extension "azure" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

I have been looking online for solutions to this problem but was unable to find any information. I know I can add extensions to the database on the Azure Portal, but 'Azure' is not one of the available options.

Trying to find further information about it online resulted in nothing, It doesnt seem a common problem unfortunately. The only thing I could find online was https://stackoverflow.com/questions/72007102/error-restoring-db-in-azure-postgresql-flexible-server-extension-azure-is-no and it is yet unresolved aswell.

I wonder if any MS Azure expert could help with what this means and how to solve it.

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2023-07-19T14:14:29.7533333+00:00

Hi @Leonard Lindenau Welcome to Microsoft Q&A thanks for posting your question

I am confused are you trying to add timesscaleDB extension or Azure? can you please clarify?

Also, I have answered a similar thread that you can refer to if this clarifies your question. https://learn.microsoft.com/en-us/answers/questions/1012183/extension-timescaledb-is-not-allow-listed-for-azur

Please provide additional information so I can better assist you.

Regards

Geetha
Leonard Lindenau 0 Reputation points

2023-07-20T07:30:51.9633333+00:00

Hi,

Sorry if my question was unclear. I have already added the timescaleDB extension without problems to the azure database!

So its only this 'azure' extension that I am looking for. Or wondering what this error message means in general. Because this 'azure' extension cannot be found when I look at the Portal to add new extensions.

The title of the question is the full error message that I receive when I try to run my 'Update Database' statement, perhaps that helps.

1 answer

Your answer

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2023-07-19T14:14:29.7533333+00:00

Hi @Leonard Lindenau Welcome to Microsoft Q&A thanks for posting your question

I am confused are you trying to add timesscaleDB extension or Azure? can you please clarify?

Also, I have answered a similar thread that you can refer to if this clarifies your question. https://learn.microsoft.com/en-us/answers/questions/1012183/extension-timescaledb-is-not-allow-listed-for-azur

Please provide additional information so I can better assist you.

Regards

Geetha
Leonard Lindenau 0 Reputation points

2023-07-20T07:30:51.9633333+00:00

Hi,

Sorry if my question was unclear. I have already added the timescaleDB extension without problems to the azure database!

So its only this 'azure' extension that I am looking for. Or wondering what this error message means in general. Because this 'azure' extension cannot be found when I look at the Portal to add new extensions.

The title of the question is the full error message that I receive when I try to run my 'Update Database' statement, perhaps that helps.

Answer 1

GeethaThatipatri-MSFT 29,547 Microsoft Employee Moderator

Hi, @Leonard Lindenau Thanks for the response

The extensions are not available as available extensions are not installed by users as this is a managed service as this is already there and is owned by azuresu

so bottom line is that you should not touch the azure extension as this is owned by the managed service super user azuresu

User's image

In the above screenshot, this extension is enabled, it is on the postgres system database and cannot be managed by end user.

I hope this information helps

Regards

Geetha

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2023-07-21T21:38:18.77+00:00

Hi, @Leonard Lindenau I am checking to see if you got a chance to look into my above response. Please let me know if you have any further questions.

Regards

Geetha
Leonard Lindenau 0 Reputation points

2023-07-24T07:46:39.42+00:00

Thanks for the answer, but can you explain why this error happens to me when I try to run the 'Update-Database' command and how to fix it? If its supposed to be active automatically why don't I have it?

The Postgres DB is a service I made on Azure so it should be there.
Any suggestions to what I can do to fix the actual error so I can run the Update-Database command?
GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2023-07-24T12:55:36.5566667+00:00

@Leonard Leonard Can you please share the error screenshot and the steps you followed?

Regards

Geetha
Leonard Lindenau 0 Reputation points

2023-07-24T13:14:02.8666667+00:00

I created PostgreSQL Database on our Azure portal and then started setting it up on our C# solution to make it work with migrations etc.

I ran the initial Add-Migration command to generate all the files as needed, which it did fine. Butwhen trying to run the 'Update-Database' command I get the following error:

"extension "azure" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL"

And I am not sure what I can do to fix it.
Leonard Lindenau 0 Reputation points

2023-07-25T07:58:45.56+00:00

For extra reference here is the screenshot of my database and the error log that I get when I run the command
GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2023-07-27T15:00:55.05+00:00

@Leonard Leonard could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details, so that we can work closely on this issue.

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards

Geetha

Share via

extension "azure" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

1 answer

Your answer