Stack Overflow
Stack Overflow

Questions tagged [azure-postgresql]

Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.

Links:

  1. Azure Database for PostgreSQL - Official site
  2. Azure Database for PostgreSQL - Documentation
171 questions
0
votes
1 answer

Failed to connect to PostgreSQL with Azure AD User via Azure data studio

I am following this post and I have added Azure AD User to my Azure PostgreSQL. When I use admin user I can connect to the server but when I change to use Azure AD-based authentication, it always got error Token get failed .... I think I'm lost,…
Jesse
  • 41
  • 3
0
votes
1 answer

Can't connect to Azure Postgresql with a Python Function App

I've followed this, this and this and a lot of other resources and still can't get connected to the database. That's why I've opened this question. I'm beyond frustrated. Hopefully someone can steer me into the right direction. Below is the steps…
nanda
  • 71
  • 6
0
votes
1 answer

Azure ADF access Postgres server

I have Azure ADF and Postgres server, and I want to connect ADF to postgress. Currently I am generating token to connect to Postgres server. And I'm using the same token to connect using ADF. The problem with the token is, it expires in 1 hour and…
Gaurang Shah
  • 11,764
  • 9
  • 74
  • 137
0
votes
1 answer

Keyword not supported: data source (Parameter 'keyword')

enter image description hereI am trying to connect to my Azure PostgreSql database server via Pg Admin but in the console after the Update-Database command I get an error: Keyword not supported: data source (Parameter…
theacidday
  • 35
  • 1
  • 7
0
votes
1 answer

Retreiving Logs in Azure Postgres SQL Database

Data has been deleted from one of my tables in the Azure Postgres SQL database. Is there any way I can figure out which user has deleted the database using log analytics workspace? Is there any specific metrics that has to be enabled to be able to…
weewoo
  • 135
  • 1
  • 5
  • 10
0
votes
0 answers

How do I migrate my local PostgreSQL database to an instance hosted on Microsoft Azure?

New to Microsoft Azure. I have added a PostgreSQL DB instance to my Azure resource group. How do I: Connect to the newly created PostgreSQL instance? On my local windows machine I'm using pgAdmin. How do I connect to the instance through…
JohnB
  • 3,921
  • 8
  • 49
  • 99
0
votes
1 answer

Postgresql Slow Under Load

We have a complex query which is dynamically built depending on different options on the customer and runs a query for data. We have functions in Azure which are running these queries to build reporting data every night, we run approx. 30k of…
user351711
  • 3,171
  • 5
  • 39
  • 74
0
votes
1 answer

Not able to connect to azure postgres db from azure data factory when SSL is enabled

I'm new to Azure Data factory and i'm trying to create data set that connects to azure postgres db where SSL is enabled, but i get the below error, any idea how to solve this error without disabling SSL on postgres. when i try to add sslmode=Allow…
user2249979
  • 48
  • 1
  • 5
0
votes
1 answer

how to move Application Insights customEvents table to postgres database?

This is for a project on Bot Framework Composer (not SDK, so i'm using built in telemetry export settings). I am looking for the best way to store event logs from bot conversations for analysis. From what I've researched, the method recommended is…
yulGM
  • 894
  • 1
  • 5
  • 14
0
votes
1 answer

Is it a kind of Microsoft Azure bug for adding pgaudit Azure postgresql?

I am trying to setup pgaudit structure in Azure PostgreSql for pgaudit log I fallowed instuction of microsoft by using below link. https://learn.microsoft.com/en-us/azure/postgresql/concepts-audit. But I can not see anything when I…
Penguen
  • 16,836
  • 42
  • 130
  • 205
0
votes
1 answer

Azure Database for PostgreSQL: "InvalidInputs" error restoring an LTR backup from Azure Backup Vault

I am trying to restore an long-term retention (LTR) Azure Database for PostgreSQL database backup using Azure Backup Vault as described in these articles: https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql (backup…
ABC XYZ
  • 11
  • 3
0
votes
1 answer

Email function for azure postgresql server

How can one write a code in azure postgresql server which can send email. As Azure postgresql sever is a fully managed by azure and no option is there for installing extensions apart from limited already available extensions.
Sabir
  • 1
0
votes
0 answers

Connecting to Azure Database for PostgreSQL using Azure AD

we are trying to connect to azure postgres DB using AD & followed the instructions provided in the below documentation url https://learn.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication Getting below error while…
ramz88
  • 30
  • 3
0
votes
2 answers

Secure connection from public Azure Function to Azure PostgreSQL

Context Azure Function accessible from the Internet (think public API). The Function app is hosted in a Elastic Premium plan. Azure-managed PostgreSQL instance (GP plan). Goal Make PostgreSQL instance accessible to the Function app only while…
Max Ivanov
  • 5,695
  • 38
  • 52
0
votes
1 answer

How can I copy whole schema/database in Azure Data Factory pipeline?

I need to copy one database from my PostgreSQL on Azure. I want to do this in ADF. In copy data activity when I specify source and target database, ADF want me to specify also table name. It doesn't make any sense when I want to copy database that…
Dominik Maciejewski
  • 25
  • 6
1 2 3
…
11 12