878 questions with Azure Database for PostgreSQL tags

Sort by: Updated
3 answers

Anon extension is not loading in postgresql flexible server version 15.3

I am trying to load "anon" extension for postgresql flexible server (15.3) . ( for "anon" referring this https://postgresql-anonymizer.readthedocs.io/en/latest/ ) however I always get this error . SQL Error [22023]: ERROR:…

Azure Database for PostgreSQL
asked 2023-09-18T11:34:32.89+00:00
Prasad Patil 5 Reputation points
commented 2024-05-17T09:58:36.85+00:00
Saul 0 Reputation points
2 answers

How can I reach the azure database for postgresql (Temporary failure in name resolution)

Hello, I created an azure database for postgresql flexible service. As for today, I can not reach anymore the server. When I try to connect with psql, I got this : psql: error: could not translate host name…

Azure Database for PostgreSQL
asked 2024-05-14T09:00:59.56+00:00
Patrick RANDRIANJATOVO 20 Reputation points
commented 2024-05-17T04:15:34.22+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
0 answers

Connect ACA with Azure postgres via managed identity

Hi, Need help in connecting Azure container app (java application) with Azure postgresqlSQL database (enabled Microsoft Entra authentication) using azure managed identity. Looking for guidance.

Azure Database for PostgreSQL
Azure Container Apps
Azure Container Apps
An Azure service that provides a general-purpose, serverless container platform.
282 questions
asked 2024-05-16T16:26:24.5166667+00:00
Lakshmi 0 Reputation points
commented 2024-05-17T01:27:01.2666667+00:00
Aki Nishikawa 800 Reputation points Microsoft Employee
0 answers

Can't create Azure Database for PostgreSQL in West Europe. Problems between different regions?

As the title says, I can't create an Azure Database for PostgreSQL in West Europe because it gives this error. Nearest one would be France South. My fist question is, is this fixable, or any reason for this that I can change and haven't figured out yet?…

Azure Database for PostgreSQL
asked 2024-05-16T12:31:23.18+00:00
Iñigo Paños Basterra 20 Reputation points
commented 2024-05-16T16:14:19.91+00:00
Iñigo Paños Basterra 20 Reputation points
2 answers One of the answers was accepted by the question author.

Azure Database for PostgreSQL flexible server - Cannot grant permission to pg_cron schedule to roles

Azure Database for PostgreSQL flexible server - I'm trying to set up pg_cron so the relevant role can schedule jobs. I'm logged in with an account with azure_pg_admin role. I can use cron under this role, e.g. setting up the housekeeping cron…

Azure Database for PostgreSQL
asked 2022-12-13T15:29:15.02+00:00
Andy Clapham 26 Reputation points
commented 2024-05-16T09:47:45.5266667+00:00
Alicja Kucharczyk 180 Reputation points Microsoft Employee
0 answers

track_commit_timestamp server parameter in Azure Database for PostgreSQL flexible server

I see that track_commit_timestamp server parameter is disabled by default in Azure Database for PostgreSQL flexible server, I would like to know if there is any performance issue if I enable it.

Azure Database for PostgreSQL
asked 2024-05-15T11:17:18.27+00:00
commented 2024-05-16T05:51:23.2033333+00:00
0 answers

I can;t connect to postgresql: Service Principal oid mismatch for role.

Weird situation, I am able to connect to my postgresql flexible instance and can query the postgresql version, but after making a change on the query, for some reason I can't event connect: Service Principal oid mismatch for role[my_user] I didn't…

Azure Database for PostgreSQL
asked 2024-04-13T22:14:22.9666667+00:00
Armando Cordova 5 Reputation points
commented 2024-05-16T05:27:57.3533333+00:00
Armando Cordova 5 Reputation points
2 answers

pgaadauth_create_principal does not exist in my flexible postgresql instance

I am trying to create users that I will later use to log in from my kubernetes service. I have set up 2 admins for this database 1. being a user group on which I am added and the other being a service principal. I tried to use the create_principal…

Azure Database for PostgreSQL
asked 2024-04-13T15:44:47.7833333+00:00
Armando Cordova 5 Reputation points
answered 2024-05-16T05:25:22.8566667+00:00
Armando Cordova 5 Reputation points
1 answer One of the answers was accepted by the question author.

How to migrate database users from Azure PostgreSQL single server to flexible server?

Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…

Azure Database for PostgreSQL
asked 2024-05-06T18:47:09.7233333+00:00
Pratik 20 Reputation points
commented 2024-05-16T00:49:53.6833333+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
0 answers

Azure Database for PostgreSQL flexible server stuck in restarting state

I changed some server parameters on my server and in the activity log the 'Update PostgreSQL server configuration' succeeded but it has now been stuck in a restarting state for over 4 hours. I have tried to stop, start and restart via CLI but all…

Azure Database for PostgreSQL
asked 2024-05-15T19:15:00.78+00:00
David Powell 0 Reputation points
commented 2024-05-15T21:36:39.7433333+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Failedto load PostgreSQL Flexible serverdatabases

Hi everyone Maybe who knows what is going on?

Azure Database for PostgreSQL
asked 2024-05-06T10:26:10.36+00:00
Alexander Lapin 80 Reputation points
accepted 2024-05-15T08:35:51.21+00:00
Alexander Lapin 80 Reputation points
1 answer One of the answers was accepted by the question author.

Deleted feature

Hello. How to restore resource in Azure using REST API? I urgently need to restore files that I accidentally deleted today: 1 Azure Database SQLPostgree; 1 Private DNS zone link to virtual network; 1 Private DNS Zone. Best Regards, Gabriel…

Azure Database for PostgreSQL
asked 2024-05-13T15:29:29.2866667+00:00
Gabriel Moraes 230 Reputation points
commented 2024-05-13T22:36:39.2466667+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
1 answer

Azure Postgres Flexible Server Cost increase without any plan changes

I'm utilizing Azure Database for PostgreSQL under the Flexible Server - General Purpose Plan with D8ds_v5 / D8ads_v5 configuration, boasting 8 vCores. After examining my expenditure through cost management tools, I've identified a possible billing…

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,100 questions
Azure Database for PostgreSQL
asked 2024-05-13T12:43:57.4566667+00:00
Nabil BEN SALAH 0 Reputation points
answered 2024-05-13T22:05:22.27+00:00
Amira Bedhiafi 16,071 Reputation points
1 answer

why plpgsql_check extension is not supported in Azure Database for PostgreSQL flexible server

plpgsql_check extension is not supported in Azure Database for PostgreSQL flexible server

Azure Database for PostgreSQL
asked 2024-05-13T06:59:20.17+00:00
answered 2024-05-13T10:10:10.71+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?

When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?

Azure Database for PostgreSQL
asked 2024-05-10T14:05:27.9533333+00:00
Cooling, Steve 20 Reputation points
accepted 2024-05-13T07:31:00.11+00:00
Cooling, Steve 20 Reputation points
1 answer

How to create private endpoint for postgres SQL flexible server?

I am unable to create a private endpoint for my postgres SQL flexible server My bicep file is like this // Parameters param location string //param env string param nameAffix string param administratorLogin string // existing resource name params param…

Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
472 questions
Azure Database for PostgreSQL
asked 2024-05-03T02:54:55.9833333+00:00
Kenny Wong (HK) 20 Reputation points
answered 2024-05-09T09:21:17.8466667+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How i can access a PostgreSQL server DB in a VNet in Azure thorugh python runbook inside an Automation Account ?

Hello team, I have a problem statement, i have an automation account in azure in which i have a python runbook in that runbook i have a script to make a connection to postgreSQL DB server and do some transactions in the DB but the problem is now i have…

Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,138 questions
Azure Database for PostgreSQL
asked 2024-05-03T13:04:21.4433333+00:00
Koushik Purva Mahendra 50 Reputation points
accepted 2024-05-08T12:40:48.11+00:00
Koushik Purva Mahendra 50 Reputation points
1 answer One of the answers was accepted by the question author.

How to enable Azure Postgresql flexible server to have both High Availability and Storage Auto-grow scaling?

Based on the documentation, Azure Postgresql flexible server supports both High Availability and auto-growth storage, but it seems that I cannot select High Availability if I have auto-growth and vice versa. Why?

Azure Database for PostgreSQL
asked 2024-05-02T08:52:08.18+00:00
Lippy 40 Reputation points
accepted 2024-05-08T01:45:35.1966667+00:00
Lippy 40 Reputation points
1 answer

How can I change location in Azure Database for PostgreSQL flexible server?

How can I change location in Azure Database for PostgreSQL flexible server? source location - East US Destination location - East US 2

Azure Database for PostgreSQL
asked 2024-04-30T10:15:10.5266667+00:00
Sonam Agrawal 0 Reputation points
commented 2024-05-07T19:06:37.1133333+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
0 answers

Is there a recommended approach for triggering actions for non-supported faults in Azure Chaos Studio?

I noticed that Azure PostgreSQL Flexible Server does not have a supported Azure Chaos Studio Fault library provider. See below: https://learn.microsoft.com/en-us/azure/chaos-studio/chaos-studio-fault-library Does Microsoft have published guidance for…

Azure Database for PostgreSQL
Chaos Studio
Chaos Studio
An Azure service used to create, run, and analyze chaos experiments to identify resilience gaps in cloud apps.
1 question
asked 2024-05-06T20:12:55.4366667+00:00
Andrew Citera 40 Reputation points
edited a comment 2024-05-07T18:24:44.1566667+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee