880 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

Azure PostgreSQL flexible Server Database Managed Identity connection

Hello, -We have created Azure postgres Flexible server with Microsoft Entra Authentication only deployment as Paas in Azure subscription. -We have added Azure Service Principal into Database admin user via Azure portal. We have created Azure VM and…

Azure Database for PostgreSQL
asked 2024-05-19T12:23:47.7566667+00:00
Maruthuvel Ramachandran 0 Reputation points
edited the question 2024-05-19T13:42:18.6733333+00:00
Sreeju Nair 11,621 Reputation points
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-19T13:13:32.9566667+00:00
Lakshmi 0 Reputation points
1 answer

I am using PostgreSQL server service on azure platform accidentally i have replaced my PostgreSQL server and all the data has been lost. The server has been recreated but the data is lost and the backups have been done from the date of new creation.

I am using PostgreSQL server service which is handled by terraform. Recently I have recreated the server and the databases inside it accidentally while making a few changes to the code. The server has been recreated but the data is lost. The backup is…

Azure Database for PostgreSQL
asked 2024-05-18T13:02:25.1166667+00:00
mungi sai meghavardhan 0 Reputation points
answered 2024-05-18T13:02:25.1366667+00:00
Q&A Assist
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

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,101 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