Azure Backup
An Azure backup service that provides built-in management at scale.
1,234 questions
1 answer
One of the answers was accepted by the question author.
What is "storage account" during postgresql flexible server restoration process?
Hello, I know that probably I am missing something, but cannot figure out what I am doing wrong. I created a backup for my Postgresql flexible server exactly as described…
asked 2024-08-01T14:11:16.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 66%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mateusz Klimas
20
Reputation points
commented 2024-08-08T09:28:25.4033333+00:00
Mateusz Klimas
20
Reputation points
1 answer
while accessing postgress flexible server from aks cluster getting error
while accessing azure postgress server from my aks cluster i am getting error error fetching from postgres, err: pq: no pg_hba.conf entry for host \"4.224.139.13\" this postgress servre is public , while seraching i got a document Check…
asked 2024-07-31T09:57:12.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 51%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kishor
0
Reputation points
answered 2024-08-07T19:28:18.02+00:00
Prrudram-MSFT
23,696
Reputation points
0 answers
messages_update_notify () not working after migrating from single server to flexible server
We recently migrated Azure postgres from single server to flexible server . There is a Trigger which are using function messages_update_notify () not working after migrating from single server to flexible server. is NOTIFY deprecated in Azure flexible…
asked 2024-08-05T11:15:08.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 82%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ranjith Kumar A
0
Reputation points
commented 2024-08-07T14:25:20.83+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Postgres Flexible Server - Segmentation Fault
We have a small database running on Azure Postgres Flexible Server. Since May 30th of 2024, we've been running into Segmentation Fault Whenever a particular procedure is called, which has a Temporary table involved When I use a base table instead, it…
asked 2024-07-16T18:48:21.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 81%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Anil Raghavan
30
Reputation points
commented 2024-08-07T13:01:21.0166667+00:00
Anil Raghavan
30
Reputation points
0 answers
Cannot connect to Azure DB for PostgresSQL flexible from different vnet
Hi, we cannot connect from an AKS pod running in one VNET to an Azure DB for PostgreSQL flexible server running in a different VNET. We can connect from an AKS pod running in the same VNET. The error is demonstrated by running curl from the pod: curl -v…
asked 2024-07-09T15:20:24.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
Wilde, Andrew
0
Reputation points
edited the question 2024-08-06T15:43:51.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChaitanyaNaykodi-MSFT
25,381
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Upgrade linked service for PostgreSQL - Data Factory
Currently I´m using the legacy LS for Postres SQL (SHIR) and the connection is working fine. I need to update the linked service (MS recomend to do it until 31/10/2024) but I´m receiving an error while testing the connection for the new one. Here´s…
asked 2024-07-31T20:40:41.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 79%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ricardo Cauduro
20
Reputation points
commented 2024-08-06T13:42:32.3433333+00:00
Ricardo Cauduro
20
Reputation points
1 answer
Azure Database for PostgreSQL error: FATAL: password authentication failed for user
Hello, For some reason, my Azure Function with System Assigned Managed Identity cannot access my Azure Database for PostgreSQL resource. Error: Failed to create PSQL Client: connection to server at "
asked 2024-07-23T21:38:42.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
ericOnline
21
Reputation points
edited the question 2024-08-06T11:14:22.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 59%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JananiRamesh-MSFT
25,816
Reputation points
1 answer
PostgreSQL Entra Authentication via AD Group: get the personal user
I have users who sign in to PostgreSQL via an AAD group as described in the docs…
asked 2024-08-02T07:48:16.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 7.000000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Julian Gimbel
31
Reputation points Microsoft Employee
answered 2024-08-03T13:47:53.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,811
Reputation points
1 answer
PostgreSQL flexible with Microsoft Entra authentication enabled - Logical Replication issue
Hi My application is using logical replication with PostgreSQL. Im trying to implement it using PostgreSQL flexible server with Microsoft Entra authentication only enabled. Im creating the admin and im able to connect to the database. Im altering…
asked 2024-07-29T08:55:17.5633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Ilya Dvorkin
5
Reputation points
commented 2024-08-02T13:47:44.5566667+00:00
Ilya Dvorkin
5
Reputation points
1 answer
One of the answers was accepted by the question author.
How to connect and query with MySQL server using Azure Machine Learning
Hi, I am currently working on a project where I need to connect to an Azure Database for MySQL using Azure Machine Learning (AML) and Python scripts. However, I want to use AML resources such as Datastore and Dataset for the connection rather than…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
MS SQL Server SELECT not showing all fields in tables, how to fix?
We use an Azure Synapse SQL server, which contains a copy of our data from a Postgresql server, and I'm trying to list all the table names and fields in each table and display them in a viz in Power BI. Since I'm doing work in PBI this makes it…
asked 2024-07-31T09:56:03.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 77%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chuck Roberts
85
Reputation points
commented 2024-08-01T13:15:31.6833333+00:00
Chuck Roberts
85
Reputation points
2 answers
After deleting a postgres flexible server the name is still taken
After deleting a postgres flexible server, the server name remains unusable. The name is specific enough to assume no one else is using this name. The server was setup in a Vnet thus creating an automatic private dns zone record. There might be a hint to…
asked 2024-07-16T08:22:34.9833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jerome Bollinger
0
Reputation points
commented 2024-08-01T07:39:26.3+00:00
ShaktiSingh-MSFT
14,811
Reputation points
1 answer
PostgreSQL Private Endpoint - Resource Not Supported
I'm having issues creating a private endpoint to my postgreSQL service. I created a basic Azure Database for PostgreSQL Server instance and spun up a test vm. I enabled the Allow access to Azure services option in connection security. When I go to…
asked 2021-03-19T16:02:07.073+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 28.000000000000004%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michael Smith
6
Reputation points
commented 2024-07-31T20:42:32.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 32%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYT%3C/text%3E%3C/svg%3E)
Yevgeniy Tsvetov
0
Reputation points
1 answer
Application deployed in Azure Kubernetes Service (AKS) hit Certificates do not conform to algorithm constraints when trying to connect Azure Database for PostgreSQL
Lately I receive news as below : When I trying to start my pod in AKS, it hit error as below when trying to connect to Azure Database for PostgreSQL – Flexible Server : Is there any idea and ways to fix this problem ?
asked 2024-07-26T14:02:15.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 59%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chee Kong Hong
0
Reputation points
commented 2024-07-30T05:14:46.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Duserla
1,780
Reputation points Microsoft Vendor
2 answers
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
asked 2024-05-21T09:38:21.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Davi, Thomas
5
Reputation points
commented 2024-07-29T08:53:27.94+00:00
Serpa
156
Reputation points
1 answer
Connect and query to Azure database for PostgresSql from Synapse Analytics
Hi, Is there a way to connect and query Azure Database for PostgresSql from Synapse Analytics.We need near real time data from postgres database to join the CosmosDB data in Synapse Analytics. I would really appreciate for the input. Thanks!
asked 2024-06-13T12:33:24.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sathya Sai Cheetirala
0
Reputation points
answered 2024-07-26T20:20:09.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 33%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Andrey Prokopenko
0
Reputation points
2 answers
Subnet issue while migrating to Postgres flexible server
What are the limitations and solutions when facing subnet issues while migrating to an Azure Database for PostgreSQL flexible server? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help…
asked 2024-07-26T18:59:14.97+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
edited an answer 2024-07-26T19:10:34.9866667+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
1 answer
Resolving Permission Denied Errors for pg_authid During PostgreSQL Migration to Azure Flexible Server
How can I resolve permission denied errors related to pg_authid and other restricted tables when migrating from a single server to an Azure PostgreSQL Flexible Server? PS - Based on common issues that we have seen from customers and other sources, we are…
asked 2024-07-26T18:43:58.77+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
answered 2024-07-26T18:45:43.3633333+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
1 answer
Azure superuser role granted a select permission to some roles -pg_stat_statements and pg_buffercache
Why are some of my roles assigned to all tables in my databases where the grantor is azure_superuser, and what can be the causes? The tables pg_stat_statements and pg_buffercache PS - Based on common issues that we have seen from customers and other…
asked 2024-07-26T18:00:35.7566667+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
edited an answer 2024-07-26T18:04:38.91+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
1 answer
Access Issues with pg_type, pg_enum, pg_namespace in Azure Flexible Server
Why am I unable to modify default columns in pg_type, pg_enum, and pg_namespace tables on Azure Flexible Server? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community
asked 2024-07-26T15:52:13.0133333+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee
answered 2024-07-26T15:53:09.4366667+00:00
GeethaThatipatri-MSFT
29,282
Reputation points Microsoft Employee