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…
Connect and query to Azure database for PostgresSql from Synapse Analytics
Hi, Is there a way to connect and query Azure Database for PostgresSql from Synapse Analytics.We need near real time data from postgres database to join the CosmosDB data in Synapse Analytics. I would really appreciate for the input. Thanks!
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
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…
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…
Not able to Insert Image data for two images Postgresql
[HttpPost] [ValidateAntiForgeryToken] public async Task<IActionResult> Create([Bind("Sno,No,Topic,QuestionTitle,Opt1,Opt2,Opt3,Opt4,Answer,Time,Correct,Solution,Imagedata,Imagesol")] Question question, IFormFile…
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,…
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…
Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity
Hi, I need to deploy a webApp running .NET Code and Azure Database for PostgreSQL flexible server. Our policy is to grant webApps/functionApps access to SQL Server/MySql Server/PostgreSQL Server via Managed Identity. While, I can see connection strings…
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…
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…
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:…
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 <>…
Azure Postgresql how to create a CAST
Hello, I am currently in the process of configuring a database within Azure Database for PostgreSQL flexible server. However when i try to create two CAST objects i get the following error: ERROR: must be owner of type integer or type…
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
Trying to create an Azure Database for PostgreSQL flexible server with same server name which was deleted
I am trying to create an Azure Database for PostgreSQL flexible server with same server name which was deleted using terraform but running into the below error. Tried creating using Azure Portal and no luck there as getting the same error there…
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
Flexible PostgreSQL server not responsive for unknown reason
Our web server suddenly started to fail to connect to our PostgreSQL flexible server, and the portal is stuck with the message 'The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status.…