Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,067 questions
1 answer
Cannot find Azure DB for PostgreSQL after auto migration
Azure recently auto migrated my PostgreSQL single server to the new flexible server. I had been waiting for the migration to finish (which ended up taking far longer than they said), and today when I logged into the portal to check the status, I can no…
asked 2024-09-24T16:32:48.1766667+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(284.8, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Brandon Rush
0
Reputation points
commented 2024-10-17T11:11:05.4533333+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, 57.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Camilo Tapia
0
Reputation points
0 answers
Resetting pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server
How do I reset the pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server? Postgres has a pg_stat_statements_reset() function which can be used but I am not able to execute this function using the server admin account. select…
asked 2024-10-17T06:46:32.6866667+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, 48%, 27%)' 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)
Jeff Chan
0
Reputation points
edited a comment 2024-10-17T10:56:16.3533333+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,715
Reputation points Microsoft Vendor
0 answers
PostgreSQL Single server to Flexible server fails on BYPASSRLS
Hello, We're using the Azure Database Migration service to migrate our Azure PostgreSQL Single server to a Flexible server. It fails with the following message: "Failed to execute query `ALTER ROLE "dummyAdmin" WITH BYPASSRLS;` with…
asked 2024-10-16T14:53:30.6633333+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(288, 32%, 37%)' 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)
Niels Delestinne
0
Reputation points
edited a comment 2024-10-17T07:25:17.7466667+00:00
Niels Delestinne
0
Reputation points
1 answer
azure postgresql flexible instance is under maintenance for prolonged period
Azure postgresql flexible instance is under maintenance for prolonged period, now over 18 hours already. I tried to contact support but that need a per-case charged support, genius microsoft, a clever way to earn more money...
asked 2024-10-15T08:43:46.7133333+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, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kenneth Shum
0
Reputation points
commented 2024-10-17T00:32:19.4866667+00:00
Kenneth Shum
0
Reputation points
2 answers
Cannot drop admin role which is role grantor because the role grantor cannot be changed.
When I create new role/group in Azure Database for PostgreSQL flexible server 16 under a workload identity admin (admin_wi) and grant the role to another user CREATE ROLE testrole; GRANT testrole TO azure_pg_admin WITH ADMIN OPTION; the role details…
asked 2024-09-25T13:00:52.2566667+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(297.6, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tomáš Krečmer
15
Reputation points
commented 2024-10-16T22:25:01.8+00:00
Oury Ba-MSFT
19,331
Reputation points Microsoft Employee
0 answers
Postgres Flexible Server 15.8 No Longer Supports ANY md5 Functionality
The 15.8 version of the server no longer supports md5 hashing. The 15.7 version allows us to call the MD5() function within the server. We DO NOT use this function for passwords or other security mechanisms. It is purely used to create a unique,…
asked 2024-10-16T19:27:38.1866667+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, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Carson
0
Reputation points
commented 2024-10-16T22:01:17.7933333+00:00
Oury Ba-MSFT
19,331
Reputation points Microsoft Employee
2 answers
Azure Postgresql 16 CREATE ROLE REPLICATION lacks membership
Hello all. We have Azure postgresql flexible server 16. I'm connected as main admin user (using password) named rixo_sa If I'm trying to create role without params, role i s created with default membership of current user rixo_sa. But the problem is…
asked 2024-09-30T13:57:26.05+00:00
LiborOndruek-3549
21
Reputation points
commented 2024-10-16T18:31:44.5033333+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, 60%, 34%)' 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)
Mahesh Kurva
245
Reputation points Microsoft Vendor
0 answers
PostgreSQL Flexible Server Not Appearing After Automatic Migration
Hello, My Azure Database for PostgreSQL Single Server was scheduled for migration to an Azure Database for PostgreSQL Flexible Server on August 31, 2024. However, the old PostgreSQL Single Server has now been deleted, and I am unable to locate the new…
asked 2024-09-18T00:40:12.2066667+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(188.79999999999998, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
NGUYEN HUNG CUONG
15
Reputation points
commented 2024-10-16T17:21:45.3733333+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
560
Reputation points Microsoft Vendor
1 answer
Time Zone Parameter Ignored in Azure Data Factory PostgreSQL Connector After Migration
I'm experiencing an issue with Azure Data Factory (ADF) when using the PostgreSQL connector. Problem: The "Time Zone" parameter in the Linked Service appears to be ignored, and timestamps are always retrieved in UTC, despite attempts to set…
![](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(131.20000000000002, 55.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
1 answer
Azure Database for PostgreSQL - Backup Logs
How can I get a log/history of backups performed on Azure Database for PostgreSQL? The documentation at https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-backup states: For servers that support up to 4-TB maximum storage, full…
asked 2022-06-15T22:02:00.223+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, 87%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Manish Jadhav
1
Reputation point
edited a comment 2024-10-16T01:11:39.9933333+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, 93%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEP%3C/text%3E%3C/svg%3E)
Evgeny Platonov
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Database for PostgreSQL flexible server stuck in restart status
Hi, My Azure Database for PostgreSQL flexible server has the storage full (100%) and no connection to it is working. I tried to restart it and "The server is currently in 'restarting' state" for more than 1 day. I'd like to set the storage size…
![](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, 90%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Is there a way to get a Token for a User on Postgres Flexible Server without having to use azure-cli?
I was looking for an alternative of azure-cli, an automatic way of obtaining tokens for regular postgres flexible server users. I wonder if it is really mandatory to use azure-cli for this task, it would be very time-consuming to ask all users to install…
asked 2024-09-25T14:02:54.73+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(131.20000000000002, 10%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Souza Costa, Tarcisio
0
Reputation points
commented 2024-10-15T11:31:27.24+00:00
Souza Costa, Tarcisio
0
Reputation points
1 answer
One of the answers was accepted by the question author.
azuresu user and NULL user occupying connections in Azure Database for PostgreSQL - Flexible Servers
I am using a Standard_B1ms postgres server in Azure which has 50 as max_connections. I am temporarily using a higher number of connections (still within the limit of 50) as I am running a migration. While running the following query, we noticed that…
asked 2024-10-14T14:48:25.57+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, 23%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nikithakoshy
40
Reputation points
accepted 2024-10-15T11:10:49.67+00:00
nikithakoshy
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Preview data of Azure Database for PostgreSQL
I have created an Azure Database for PostgreSQL in Azure Portal. I created a database, a schema and a table. I also created a linked service and a dataset in Azure Datafactory. If I go on this dataset, enter schema name and table name, and then I click…
asked 2024-10-11T18:35:13.4033333+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(166.4, 44%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dirk Sachse
126
Reputation points
accepted 2024-10-15T10:48:22.1533333+00:00
Dirk Sachse
126
Reputation points
1 answer
The server is in updating state for too long for Azure Database for PostgreSQL - Flexible Server
Actually my postgresql dtabase in updating state for too long, I'm not even able to connect.
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,067 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
282 questions
asked 2024-10-10T15:17:46.5933333+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(224.00000000000003, 63%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
Hitesh Gupta
0
Reputation points
commented 2024-10-14T17:09:02.4366667+00:00
Oury Ba-MSFT
19,331
Reputation points Microsoft Employee
1 answer
no pg_hba.conf entry error
Hello, I receive the following error when trying to connect to an Azure Database for PostgreSQL flexible server. psql: error: connection to server at "example.postgres.database.azure.com" (20.39.50.159), port 5432 failed: SSL error:…
asked 2023-08-31T23:58:54.5+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(32, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Evan Corkrean
30
Reputation points
commented 2024-10-14T15:26:35.6733333+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, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jacek Tomaszewski
5
Reputation points
1 answer
postgresql - azuresu wrong backend_type encoding in pg_stat_activity
When I list pg_stat_activity, I see process from azuresu user which has wrong encoded text in backend_type column: select * from pg_stat_activity; datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr |…
asked 2024-07-23T14:11:19.91+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(112.00000000000001, 4%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gajzler, Simon
5
Reputation points
commented 2024-10-14T14:46:45.5766667+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(137.6, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Savan Dosanjh
0
Reputation points
1 answer
Azure DB for PostgreSQL Flexible Server - Reporting for Backup Restore Points
Hello, Building a solution with will scale out Azure PostgreSQL Flexible Server instances. Backup is a stringent requirement which I need reporting automation & alerting for. At present, all I'm able to see in the "Backup and Restore"…
asked 2024-10-11T04:10:08.3133333+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(182.40000000000003, 20%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWJ%3C/text%3E%3C/svg%3E)
WHITE, J. (JADA)
0
Reputation points
answered 2024-10-11T08:21:03.2566667+00:00
SadiqhAhmed-MSFT
45,516
Reputation points Microsoft Employee
1 answer
How to geo-restore a private postgres flexible server having private endpoints
Dear community, I have a Postgres Flexible Server with the following characteristics: Public access is disabled A private endpoint has been deployed in a VNet (so it's not a VNet Integration as we used to do until recently) simple availability …
![](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(32, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
![](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(112.00000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK2%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Automigration from Azure Database for Postgresql – Single Server to Flexible Server taking too long
Hi, I am trying to migrate my Postgresql single server to a flexible server with automigration, but it has been stuck in the 'In Progress' status for two days now. All I can track is the single server's FQDN has changed, the old FQDN points to some IP…
asked 2024-09-17T03:03:36.2333333+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, 50%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQD%3C/text%3E%3C/svg%3E)
Quan Do Anh
20
Reputation points
edited the question 2024-10-10T06:17:29.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(275.2, 41%, 36%)' 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)
AnuragSingh-MSFT
21,381
Reputation points