961 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

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…

Azure Database for PostgreSQL
asked 2024-06-19T08:43:32.8366667+00:00
gpatounas 0 Reputation points
commented 2024-06-25T10:35:31.5966667+00:00
gpatounas 0 Reputation points
2 answers One of the answers was accepted by the question author.

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
asked 2024-05-18T13:02:25.1166667+00:00
mungi sai meghavardhan 20 Reputation points
accepted 2024-06-25T06:25:19.44+00:00
mungi sai meghavardhan 20 Reputation points
1 answer

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

Azure Database for PostgreSQL
asked 2024-06-19T13:08:16.8833333+00:00
Srinivas Bhimireddi 0 Reputation points
answered 2024-06-24T22:28:39.7466667+00:00
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2024-06-19T18:50:58.1066667+00:00
Erick Salazar 0 Reputation points
commented 2024-06-24T19:11:15.36+00:00
Rahul Randive 9,176 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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.

Azure Database for PostgreSQL
asked 2024-05-15T11:17:18.27+00:00
accepted 2024-06-23T02:44:50.1133333+00:00
1 answer

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,

Azure Database for PostgreSQL
asked 2024-06-20T12:21:48.9633333+00:00
Rajeev Kumar Dave 21 Reputation points
answered 2024-06-21T21:00:29.22+00:00
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
1 answer

ORM Support for Azure Database for Postgresql - felxible server

Do we have support to ORM using NodeJS for Azure Database for Postgresql - felxible server?

Azure Database for PostgreSQL
asked 2024-06-18T08:05:47.3+00:00
Gumudavelli, Dheeraj /IN 0 Reputation points
answered 2024-06-21T04:50:42.6+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
0 answers

appservice changing method as GET instead of POST

DMZ API changing method as GET instead of POST

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,996 questions
Azure Database for PostgreSQL
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,407 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
2,645 questions
asked 2024-06-20T17:02:42.8166667+00:00
Paras Gandhi 0 Reputation points
edited the question 2024-06-21T01:14:19.67+00:00
Lan Huang-MSFT 28,841 Reputation points Microsoft Vendor
1 answer

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.

Azure Database for PostgreSQL
asked 2024-06-19T09:58:03.53+00:00
Buelah Karumuru 0 Reputation points
answered 2024-06-20T03:11:31.44+00:00
Rahul Randive 9,176 Reputation points Microsoft Employee
0 answers

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…

Azure Database for PostgreSQL
asked 2024-06-13T10:28:56.7366667+00:00
Thennarasu Duraikannu 0 Reputation points
commented 2024-06-17T03:57:03.55+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2024-06-14T08:50:33.0466667+00:00
Michał Salasa 0 Reputation points
answered 2024-06-14T09:41:30.4966667+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2024-06-12T19:41:39.73+00:00
Kristine Kisman 20 Reputation points
accepted 2024-06-13T13:38:50.4266667+00:00
Kristine Kisman 20 Reputation points
1 answer

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
asked 2024-05-22T12:49:03.72+00:00
Kamal Rathnayake 31 Reputation points MVP
commented 2024-06-13T09:37:08.3266667+00:00
MChogo 25 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2024-05-21T06:48:24.7766667+00:00
Jonas vR 20 Reputation points
accepted 2024-06-12T06:15:45.8966667+00:00
Jonas vR 20 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-06-09T21:25:29.1066667+00:00
D4Dilip 30 Reputation points
accepted 2024-06-11T18:42:35.8+00:00
D4Dilip 30 Reputation points
1 answer

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
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
Azure Database for PostgreSQL
asked 2024-06-10T11:31:09.75+00:00
Laura Balbi 0 Reputation points
commented 2024-06-11T09:18:58.1366667+00:00
Amira Bedhiafi 20,176 Reputation points
2 answers

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
Azure Database for PostgreSQL
asked 2024-05-28T07:10:35.32+00:00
Sai Varma Eswararaju 0 Reputation points
commented 2024-06-10T08:29:07.41+00:00
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
1 answer

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:…

Azure Database for PostgreSQL
Azure Container Apps
Azure Container Apps
An Azure service that provides a general-purpose, serverless container platform.
346 questions
asked 2024-05-28T06:16:03.5266667+00:00
Yedukondalu Mammu 0 Reputation points
commented 2024-06-06T23:15:49.1166667+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2024-05-31T04:21:03.9433333+00:00
Manikandan M 0 Reputation points
commented 2024-06-06T05:19:34.7133333+00:00
Manikandan M 0 Reputation points
1 answer

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 Database for PostgreSQL
asked 2022-02-17T19:49:54.363+00:00
Kopl 166 Reputation points
commented 2024-06-05T17:40:34.3533333+00:00