Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,219 questions
1 answer
Flexible Postgres Server unavailable
My Flexible Postgres Server is completely unavailable. I can connect to it or describe it via the Portal or the CLI az postgres flexible-server db show \ …
![](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(163.2, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
1 answer
Data of type AzureDiagnostics is being dropped due to incorrect format at lineOffset: 247. Exception message: Unexpected character encountered while parsing value: \. Path 'records[247].resultDescription', line 1, position 155215.
The Diag setting of my Postgresql seems to send wrong data to my log analytics workspace: https://learn.microsoft.com/en-us/answers/questions/1701891/log-analytics-workspace-reports-10-warnings Data of type AzureDiagnostics is being dropped…
asked 2025-02-26T10:37:01.24+00:00
Nicolas Lhoir
0
Reputation points
commented 2025-02-28T05:30:23.9233333+00:00
Vinodh247
28,386
Reputation points MVP
0 answers
PostgreSQL in Azure loading high CPU lately
Our system was running fine until the last few days it has been very slow. I checked and noticed that PostgreSQL has been getting full CPU load lately. Can you help me what happened, is there something running in the background that I don't know about?
asked 2025-02-27T19:00:13.46+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, 79%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Hong Phuc Nguyen
0
Reputation points
edited the question 2025-02-28T00:47:12.7633333+00:00
Alison A
650
Reputation points Microsoft Vendor
0 answers
Migration from Postgresql Single Server to Flexible stuck
Hi, I triggered migration from single server to flexible server (7 databases). 5 were migrated successfully but it stuck on 6. For last 3h I'm having "Migration data" and when I click on details I can see this: Is there any way to check what…
asked 2025-02-27T13:17:08.0466667+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(214.4, 86%, 30%)' 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)
Szwed, Slawomir
0
Reputation points
commented 2025-02-27T21:24:02.46+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, 47%, 31%)' 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)
Mallaiah Sangi
85
Reputation points Microsoft Vendor
0 answers
Cannot Upgrade Postgresql Flexible Server to V14
I'm trying to upgrade my azure postgresql flexible server v13 instance to v14, and keep getting the standard InternalServerError "An unexpected error occured while processing the request." error. I've also followed the full upgrade…
asked 2025-02-26T16:08:20.15+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(22.400000000000002, 36%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Ryan H
0
Reputation points
commented 2025-02-27T20:37:33.48+00:00
Mallaiah Sangi
85
Reputation points Microsoft Vendor
1 answer
Unsupported server parameter after Azure flexible PostgreSQL server upgrade v11 to v13
We performed a PostgreSQL version upgrade (v11 -> v13) and cannot change any server parameter via the GUI nor via CLI anymore. The error is: (ParameterNotExists) The Parameter [azure.allow_hostname_in_username] is invalid or unsupported in current PG…
asked 2025-02-24T14:13:58.47+00:00
Johannes Boyne
21
Reputation points
commented 2025-02-27T20:06:39.49+00:00
Oury Ba-MSFT
20,351
Reputation points Microsoft Employee
0 answers
Can't change the owner of a table in azure database for postgreSQL flexible server
I can't change the owner of a table even though I am using the server admin. The error message is 'must be able to SET ROLE "ROLE NAME REDACTED"'. Is there any way to give the server admin the needed permissions? Since it is a managed server,…
asked 2025-02-27T19:56:09.4666667+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(147.20000000000002, 22%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yannic Jörg
0
Reputation points
edited the question 2025-02-27T19:58:17.4266667+00:00
Yannic Jörg
0
Reputation points
2 answers
Postgres Flexible Server stuck in “starting” state for two days
Hello, everyone. I started my Postgres Flexible DB server Wednesday morning, and it remains stuck in the “starting” state. How can a restart this server? The “stop” and “restart” buttons are all greyed out. Can I “self-rescue” by running a…
asked 2025-02-21T11:56:07.9733333+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(195.2, 56.00000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jonathan Craft
0
Reputation points
edited a comment 2025-02-27T08:44:03.8033333+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(249.60000000000002, 51%, 34%)' 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)
Adithya Prasad K
10
Reputation points Microsoft Vendor
1 answer
Connection DoesNotExistsError:connection was closed in the middle of operation
Hi, Users are complaining "Connection DoesNotExistsError:connection was closed in the middle of operation" error while using a streamlit UI based web app deployed on Azure. Thanks for help!
![](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(163.2, 27%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
0 answers
How to prevent/deal with corrupted WAL for Azure Database for PostgreSQL flexible server.
We are running a Postgres instance with a Timescale DB extension on Azure and are currently not able to log into the service from any client. With the error "Connection refused Is the server running on that host and accepting TCP/IP…
asked 2025-02-24T10:47:06.3266667+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(140.8, 71%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Konrad Wölms
0
Reputation points
commented 2025-02-27T07:10:47.63+00:00
Adithya Prasad K
10
Reputation points Microsoft Vendor
1 answer
Metrics for Storage incorrect
The storage metrics for my PostgreSQL Flexible server no longer update. They do not reflect the true size/usage of the storage on the server. I have restarted the database multiple times to no effect.
asked 2025-02-17T10:50:30.4166667+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(204.8, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Conor Nash
0
Reputation points
commented 2025-02-27T04:53:56.12+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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
80
Reputation points Microsoft Vendor
0 answers
PostgreSQL Single Server migration in flexible server.
Team, Currently, we are using Azure PostgreSQL Single Server, but as its support has ended, we are required to migrate to Azure PostgreSQL Flexible Server. We have received a notification that the default migration is scheduled for March 16. Since this…
asked 2025-02-26T06:20:06.45+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(243.2, 77%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tripesh Dhoriya
0
Reputation points
commented 2025-02-26T11:12:11.9966667+00:00
Tripesh Dhoriya
0
Reputation points
2 answers
The server is currently in 'disabled' state.
Our PostgreSQL server/VM is in a 'disabled' state. because the spending limit in the subscription has been reached. After increasing the limit, all other VMs were re-enabled except the database server. I have tried to resolve this with Azure paid…
asked 2025-01-10T11:08:34.3666667+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(99.2, 53%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Christian Schmittel
0
Reputation points
commented 2025-02-26T05:55:04.06+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(19.2, 34%, 11%)' 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)
Alex Rothberg
20
Reputation points
2 answers
Azure PostgreSQL Flexible Server Stuck in Restarting State from past 3 hours.
Azure PostgreSQL Flexible Server has been stuck in the "restarting" state for the past 3 hours. I am unable to connect to the server or make any changes. The logs show that storage utilization is at 100%. Since I can't access the server, I'm…
asked 2025-02-25T07:12:47.56+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(204.8, 82%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Saurabh Gupta (Quadrant Resource)
0
Reputation points
commented 2025-02-26T02:12:24.97+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,485
Reputation points Microsoft Vendor
1 answer
Azure Cosmos for PostgresDB provisioning error when specifying authConfig
I'm seeing an issue when trying to provision a Cosmos for PostgresDB instance using terraform/arm templates. I can provision this configuration successfully, but if I uncomment the 'authConfig' block it fails with a "500 - Internal Server…
asked 2024-12-31T10:53:33.0433333+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(25.6, 45%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PGT
0
Reputation points
commented 2025-02-26T00:07:51.83+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(108.80000000000001, 95%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alexandra Avendano
0
Reputation points Microsoft Employee
2 answers
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,517
Reputation points Microsoft Employee
answered 2025-02-25T11:52:33.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(80, 40%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gianluca Valente
0
Reputation points
1 answer
Error migrating from single to flex postgres
After 16h in online migration the process failed with the following error: DB004: Failed to fetch the current migrations status. Please reference MigrationId 3691c83d-e8ba-4fca-a612-88fd534ed620, when contacting Microsoft customer support. Parameter…
![](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, 28.000000000000004%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
0 answers
My connection to flexible server was working but now it seems that azure is blocking it
My connection to the flexible server was working fine, but it now appears that Azure is blocking it. This issue started on Saturday, even though this configuration had been working for over seven months.
asked 2025-02-24T13:41:57.8766667+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(44.800000000000004, 66%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Antonio Mendez
0
Reputation points
edited the question 2025-02-24T23:46:09.7+00:00
TP
106K
Reputation points
3 answers
One of the answers was accepted by the question author.
my postgresSQL, server parameters dont have pgbouncer
why my azure postgresSQL, server parameters dont have pgbouncer to enable... https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-pgbouncer?WT.mc_id=Portal-Microsoft_Azure_Support
asked 2022-03-03T10:36:14.143+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(92.8, 37%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
rui dias
21
Reputation points
commented 2025-02-24T15:50:39.0633333+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(9.6, 42%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Saurabh Talele
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Database for PostgreSQL - Flexible Server unavailable twice a day
We are running Azure Database for PostgreSQL - Flexible Server. According to the metrics, the system is not under heavy load at all (memory is constantly at approx. 60%, CPU 12% with no peaks). Database is not available approx. twice a day - this problem…
asked 2025-02-19T21:18:58.1233333+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, 11%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Martin Gubis
20
Reputation points
accepted 2025-02-24T15:49:22.16+00:00
Martin Gubis
20
Reputation points