1,070 questions with Azure Database for PostgreSQL tags

Sort by: Updated
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
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
Azure Database for PostgreSQL
asked 2024-10-19T09:07:45.6766667+00:00
Eelco 85 Reputation points
answered 2024-10-19T11:34:12.69+00:00
Vinodh247 21,881 Reputation points
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,…

Azure Database for PostgreSQL
asked 2024-10-16T19:27:38.1866667+00:00
David Carson 0 Reputation points
commented 2024-10-18T21:41:59.6333333+00:00
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…

Azure Database for PostgreSQL
asked 2024-10-17T20:12:10.42+00:00
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 …

Azure Database for PostgreSQL
asked 2024-07-23T14:45:44.4566667+00:00
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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-09-18T00:40:12.2066667+00:00
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

Azure Database for PostgreSQL
asked 2024-10-18T12:49:24.14+00:00
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…

Azure Database for PostgreSQL
asked 2024-10-17T06:46:32.6866667+00:00
Jeff Chan 0 Reputation points
commented 2024-10-18T14:02:29.1066667+00:00
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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,740 questions
Azure Database for PostgreSQL
asked 2024-10-11T11:52:38.2166667+00:00
icatii 25 Reputation points
accepted 2024-10-18T07:42:48.2266667+00:00
icatii 25 Reputation points
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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-10-16T14:53:30.6633333+00:00
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 |…

Azure Database for PostgreSQL
asked 2024-07-23T14:11:19.91+00:00
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":…

Azure Database for PostgreSQL
asked 2024-07-30T18:32:19.02+00:00
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…

Azure Database for PostgreSQL
asked 2024-09-30T13:57:26.05+00:00
LiborOndruek-3549 21 Reputation points
commented 2024-10-17T17:29:44.5266667+00:00
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…

Azure Database for PostgreSQL
asked 2024-09-24T16:32:48.1766667+00:00
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...

Azure Database for PostgreSQL
asked 2024-10-15T08:43:46.7133333+00:00
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…

Azure Database for PostgreSQL
asked 2024-09-25T13:00:52.2566667+00:00
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…

Azure Database for PostgreSQL
asked 2022-06-15T22:02:00.223+00:00
Manish Jadhav 1 Reputation point
edited a comment 2024-10-16T01:11:39.9933333+00:00
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…

Azure Database for PostgreSQL
asked 2024-10-08T11:09:27.5333333+00:00
Alex 20 Reputation points
accepted 2024-10-15T13:07:52.7066667+00:00
Alex 20 Reputation points
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…

Azure Database for PostgreSQL
asked 2024-09-25T14:02:54.73+00:00
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…

Azure Database for PostgreSQL
asked 2024-10-14T14:48:25.57+00:00
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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,740 questions
Azure Database for PostgreSQL
asked 2024-10-11T18:35:13.4033333+00:00
Dirk Sachse 126 Reputation points
accepted 2024-10-15T10:48:22.1533333+00:00
Dirk Sachse 126 Reputation points