Replication lag in PostgreSQL Replay Lag is extremely high (236:41:55.093431
Replica showing Active.One more repliucation slot showing delay PostgreSQL Replay Lag is extremely high (236:41:55.093431
Azure Database for PostgreSQL
I can't scale compute on my postgres flexible server hosted in East US
I don't have any choice to upgrade my compute on postgres flexible server. The server is in East US ... As you can see above, there are no other choices... I need to switch to an 8 vCores SKU ... Why is it not available? I know you are resource…
Azure Database for PostgreSQL
updating state is taking too long
The server is currently in 'updating' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long. I need someone to work with us asap
Azure Database for PostgreSQL
How can i change extension schema
How can i change extension(postgis) schema from public to my custom schema in Azure Database FOR PostgreSQL flexible servers?
Azure Database for PostgreSQL
When Azure Database for PostgreSQL flexible servers impacting event in East US will be resolved
Hi community, Does anyone know the ETA of the current issue for Azure Database for PostgreSQL flexible servers impacting event in East US will be recovered? https://app.azure.com/h/RLDP-VW8/c26251 It has been more than a month, our PROD is running in…
Azure Database for PostgreSQL
Upgrading Azure Database for PostgreSQL flexible server from 15.14 to 16 or 17 versions failed
During process upgrade Azure Database for PostgreSQL flexible server from 15.14 to 16 or 17 versions I see this error: { "code": "ParameterOutOfRange", "message": "The value of the 'Version' should be in: []. Verify…
Azure Database for PostgreSQL
How to buy Reservation for Postgresql flexible servers HA instance
I can't seem to find any official documentation on precisely how to buy Azure PostgreSQL's flexible server instance's High Availability instance (Secondary instance). I am aware buying the Reservation will apply for the primary instance. Does anyone have…
Azure Database for PostgreSQL
PostgreSQL flexible server upgrades fail with InternalServerError
Hi, all my PG flexible server upgrades from 16.9 to 17.6 fail with the following status: "statusMessage":…
Azure Database for PostgreSQL
pg_trgm Extension Not Allowed on Azure Database for PostgreSQL Flexible Server – Alternatives and Cloud Comparison
Dear Microsoft Community, We are currently exploring advanced search functionality for our application hosted on Azure Database for PostgreSQL (Flexible Server). Our use case involves fuzzy text search on a product catalog, specifically using a string…
Azure Database for PostgreSQL
Cannot create new Azure Postgres Flexible Server in eastus despite quota increase
When creating another Azure Postgres Flexible Server through terraform we get the error below. We do have existing Azure Postgres Flexible Server in that region. After requesting a quota increase the error persists. Error: creating Flexible Server…
Azure Database for PostgreSQL
How to add pgaadauth in azure pg flexible servers
Hello, I am trying to add pgaadauth as a server parameter under the azure.extensions and it is not listed as an option to add. But when run the below query: SELECT * FROM pg_available_extensions; pgaadauth is listed as version 1.7 and installed is…
Azure Database for PostgreSQL
Remove stale principal from Azure PostgreSQL flexible server database
Our Azure PostgreSQL Flexible Server has a stale AAD principal mapping created with pgaadauth_create_principal(). The corresponding Managed Identity was deleted and recreated, so its Object ID changed. We cannot drop or update the principal because…
Azure Database for PostgreSQL
Zone Redundant HA cannot be enabled on Azure flexible Postgres Server
I cannot enable Zone Redundant HA on my Azure flexible Postgres Server even though it is in East US and I have sufficient quota left for the compute VM. The message says the region does not support it, but your documentation says it does and I don't see…
Azure Database for PostgreSQL
Resource was created with failed state and cannot be deleted
I created Azure Database for PostgreSQL flexible server but it ended up in a failed state. I want to delete this resource but it doesn't allow me. I get the following error: The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers'…
Azure Database for PostgreSQL
Error restoring backup An unexpected error occured while processing the request. Tracking ID: '3f9abf0b-3c73-47ba-b858-a61ca72fb77f' (código: InternalServerError)
When trying to restore a backup using the Azure portal, I have tried several ways with different availability zones, following the help suggestions and in all cases, I get this error. Please your help …
Azure Database for PostgreSQL
Unable to add tags to an Azure Database for PostgreSQL flexible server
We are trying to add tags to an existing Azure Database for PostgreSQL flexible server. We have tried via the Azure Portal and the CLI, but it will not work. The command I run is: az postgres flexible-server update -n <servername> -g…
Azure Database for PostgreSQL
Enable TimescaleDB for PostgreSQl Flexi server
Hello Azure Support Team, Could you please confirm if Azure Database for PostgreSQL Flexible Server currently supports installing and running TimescaleDB Community Edition (preferably the latest stable release)? If so, are there any version limitations…
Azure Database for PostgreSQL
Create extension azure_storage fails with permission denied
Running CREATE EXTENSION IF NOT EXISTS azure_storage; against a new database on Azure Database for PostgreSQL flexible server (16.9) fails with ERROR: permission denied to alter restricted role "azure_pg_admin" The extension is on the allow…
Azure Database for PostgreSQL
The removed database still works.
I deleted the Postgres database and its resource group on August 29th (see the attached image), but it’s still working. I can’t find it anywhere in the Azure portal—what am I doing wrong?
Azure Database for PostgreSQL
How to fix sudden POSTGRES database server connectivity issue and failing restart
My database server suddenly began refusing all connections, even in Azure portal. I tried to restart it through the portal UI and the operation failed. I then stopped the server and now it is stuck in "starting" for the last 30 minutes. This is…