Permission denied to ALTER DEFAULT PRIVILEGES
I'm trying to alter the default privileges of a role (roleB) that I am a member of, to allow it to modify objects created by another role (roleA) that I am also a member of. I have the inherit attribute set on my role. This is on a PostgreSQL 16 instance…
I am using PostgreSQL server service on azure platform accidentally i have replaced my PostgreSQL server and all the data has been lost. The server has been recreated but the data is lost and the backups have been done from the date of new creation.
I am using PostgreSQL server service which is handled by terraform. Recently I have recreated the server and the databases inside it accidentally while making a few changes to the code. The server has been recreated but the data is lost. The backup is…
Azure Database for PostgreSQL flexible server Is not getting Started
Azure Database for PostgreSQL flexible server Is not getting Started. and server is currently in starting state. And getting below waring massage in portal: "The server is currently in 'starting' state. Please wait for the operation to complete.…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
PosgresQL flexible status "starting"
El día de hoy 19 de junio 2024, el inicio diario automatizado del server flexible se quedó en status "starting"; ya tiene varias horas en ese status. Por comandos de azure client, marca errorer al intentar, detener, iniciar y reiniciar. An…
track_commit_timestamp server parameter in Azure Database for PostgreSQL flexible server
I see that track_commit_timestamp server parameter is disabled by default in Azure Database for PostgreSQL flexible server, I would like to know if there is any performance issue if I enable it.
How to Publish PowerBI report with Azure PostGres flexible server Database
I have created Power BI report connecting MS Postgres Flexible server on prem using Vnet . But when I am publishing it is on Cloud it is giving us error or not able to connect,
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
ORM Support for Azure Database for Postgresql - felxible server
Do we have support to ORM using NodeJS for Azure Database for Postgresql - felxible server?
appservice changing method as GET instead of POST
DMZ API changing method as GET instead of POST
The server is currently in 'starting' 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.
The server is currently in 'starting' 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.
Get " https://management.azure.com/subscriptions/0444938f-8b72/resourceGroups/rg-prd-backend-db-psql/providers/Microsoft.DBforPostgreSQL/flexibleServers/psql--001?api-version=2023-06-01-preview" : context deadline exceeded
I have deployed Azure postgreSQL flexible server with version 16.2 using Terraform. It was working fine, since last week, post the HA is had an issue due to Azure policy we lost the connection to the DB server from Azure portal. We can see the db…
PSQL flexible server is in 'updating' state too long. Can't do anything with instance and databases.
I decided to upgrade from GUI Compute size of my PostgreSQL flexible server from Standard_B1ms (1vC, 2GB) to Standard_B2s (2vC, 4GB). Unfortunately, it is running about 24 hours (status "Updating"), and I can't do anything, even stop the update…
Can I change to owner of a database in Azure Database for PostgreSQL flexible server?
I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…
How to Handle Point-in-Time Restore with Azure PostgreSQL and Terraform?
Hello, I'm using an Azure PostgreSQL database and need to perform a point-in-time restore (PITR) as part of a disaster recovery drill. I can successfully restore the database to a new server and update my application to point to this new server. However,…
![](https://techprofile.blob.core.windows.net/images/ROgJ-EMm-kyQxc7b6pyGZw.png?8D9D0C)
Azure Database for PostgreSQL flexible server stuck in restart state
Hi, our Azure Database for PostgreSQL flexible server is stuck in restarting state. We noticed to late that storage is utilized 100% and now we can’t increase the instance or do any modifications. We can't even delete it, it just states that it is in…
Migrate PostgreSQL production database from AWS RDS to Azure PostgreSQL Flexible Server
We have moved our web apps from AWS ec2 instances to azure web apps but our database is still running on AWS RDS it’s a high traffic application and we cannot afford any downtime . any suggestion how can we move our production PostgreSQL db to azure…
Connecting Azure Database for PostgreSQL and Data Factory
Hello, I'd want to connect my Azure Database for PostgreSQL (from now on referred as DB) to use it as a dataset in Data Factory (from now on referred as ADF). My DB is in a private network in a resource group (rg_1) my ADF is public and is in a…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
Azure data factory
Dear Team, I need to copy a data from a single table to multiple tables with mapping of columns in azure data factory by connecting with a PostgreSQL server. only one source table and I need to send that source data to the multiple sink tables by…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Reading credentials from azure failed: DefaultAzureCredential failed to retrieve a token from the included credentials.
0 I'm trying read azure default credentials but fails with following error DefaultAzureCredential failed to retrieve a token from the included credentials. 04:54:12.161 lrr-data-service-perf-green-x Attempted credentials: EnvironmentCredential:…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Postgresql flexible server parameter set up is failing with server busy error
Hi, I am trying to deploy Azure Postgresql flexible server through Bicep and GHA pipelines, the deployment is failing in configuration step with the following error, i am trying to deploy pg 16 version. can someone please help with this…
Deleting active connections in Azure Postgresql
I would like to delete active connections in my Azure SQL Database for Postgres. I have logged into the database as admin and tried: SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'postgres' AND pid <>…