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…
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,…
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…
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 …
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…
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
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…
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…
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…
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 |…
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 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…
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 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...
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 - 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 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…
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…
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…
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…