Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,031 questions
1 answer
Extra PostgreSQL product added to my Invoice, paying for 2 PostgreSQL database products now
I am using a PostgreSQL database, type 'Flexible Server Storage', costing me about 12 euro every month. On the new Invoice this month, an extra PostgreSQL product has been added, type ' Flexible Server Burstable BS Series Compute', costing me about 13…
Azure
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,070 questions
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-18T21:41:59.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(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
0 answers
PostGresSQL - Flexible Server Name Already Exists
We had a postgres flexible server created through terraform in the East US region with the name "prtleusdev-db-flex-server" in a resource group that was in East US. Someone accidentally tried to re-create the database in North Central US but…
asked 2024-10-17T20:12:10.42+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(236.8, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Ben Koth
0
Reputation points
commented 2024-10-18T18:45:42.03+00:00
Sai Raghunadh M
560
Reputation points Microsoft Vendor
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 …
asked 2024-07-23T14:45:44.4566667+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, 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)
JPR
5
Reputation points
commented 2024-10-18T17:13:29.4666667+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
1 answer
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-18T16:22:02.2933333+00:00
Sai Raghunadh M
560
Reputation points Microsoft Vendor
1 answer
Is there a way to restore deleted PostgreSQL server. If backup is not enabled. If yes, please let us know to restore PostgreSWL
I have accidentally deleted PostgreSQL Server. Need to restore it back
asked 2024-10-18T12:49:24.14+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, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rakshith M L
0
Reputation points
commented 2024-10-18T15:40:52.15+00:00
SUNOJ KUMAR YELURU
14,376
Reputation points MVP
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
commented 2024-10-18T14:02:29.1066667+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,790
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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
One of the answers was accepted by the question author.
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
25
Reputation points
edited a comment 2024-10-18T07:31:41.5033333+00:00
Niels Delestinne
25
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-17T21:49:35.2+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Error creating a Flexible Postgres Database in Azure
Getting this error when creating the database trough the Azure portal in south central US { "status": "Failed", "error": { "code": "InternalServerError", "message":…
asked 2024-07-30T18:32:19.02+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(236.8, 61%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Juan Ribon
20
Reputation points
accepted 2024-10-17T21:00:48.3433333+00:00
Juan Ribon
20
Reputation points
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-17T17:29:44.5266667+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
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-17T16:14:36.2266667+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
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,346
Reputation points Microsoft Employee
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
60
Reputation points
accepted 2024-10-15T11:10:49.67+00:00
nikithakoshy
60
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