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
1
vote
1 answer

Azure Private Endpoint for postgresql is not working with multiple Vnet

I have created two vnets (Main APP vnet, Reporting APP vnet both are in same region). My azure postgres database(PAAS) is hosted on main app vnet. I have created two private end point. First private end point is used for Main App, vnet…
Debugger
  • 690
  • 1
  • 18
  • 41
1
vote
3 answers

Installation of pg_cron on Azure Flexible PostgeSQL

I am trying to install pg-cron extension for Azure PostgreSQL Flexible server. According to documentation found here: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#postgres-13-extensions pg_cron is available…
Tcheslav Tcheslav
  • 60
  • 1
  • 8
1
vote
2 answers

How to connect a AKS cluster to to an Azure hosted postgresql w/o routing over the internet

I created a Azure hosted Postgresql instance and got the public name to access it. After configuring the security settings I am able to access it from every location I want. If I configure the services in my AKS cluster with that name, then the IP…
OkieOth
  • 3,604
  • 1
  • 19
  • 29
1
vote
1 answer

How to Create a Service Principal for Azure database for PostgreSql single server

As per the documentation from Microsoft for Data encryption for Azure Database for PostgreSQL Single server by using the Azure portal , the steps mentioned tell to create a service principal for Azure PostgreSql single server option, while adding an…
S2S2
  • 8,322
  • 5
  • 37
  • 65
1
vote
0 answers

Storing incremental changes in Azure postgresql database from prod server database

Background : I have my prod postgresql db on a remote server and another DB some other azure server. 2nd db has been restored with the full backup of prod db. I need to transfer all the latest changes in the 2nd DB which is on some other server. As…
ABHISHEK KUMAR SINGH
  • 91
  • 4
1
vote
1 answer

Choosing the correct DB type

I have to create a DB which has around 130 million records which is around 90GB when loaded. I want to host this in the azure. DB modifications will happen once a day as a batch operation. Searching has to be done more often which should return the…
KTB
  • 1,499
  • 6
  • 27
  • 43
1
vote
0 answers

Non-owner being able to drop table in PostgreSQL (Azure)

I'm running PostgreSQL 11.11 in Azure (Azure Database for PostgreSQL). I have two users, A and B, who are both members of the default azure_pg_admin role. My problem is that role B can drop tables created (and owned) by user A, which shouldn't…
Edmond Dantès
  • 11
  • 1
1
vote
3 answers

Replication of Azure Postgres Flexible Server?

Is replication not supported for Azure Postgres Flexible Server? Zone redundancy can not be treated as alternative for Disaster Recovery. Such an important feature is missing. May be until it is in preview?
Abhijeet
  • 13,562
  • 26
  • 94
  • 175
1
vote
1 answer

To load data from Azure Delta Lake & Azure Data Bricks to Postgres SQL in single transaction( To insert 10 tables of data and rollback for any errors)

I would like to load data (around 10 tables) from Azure delta lake to azure postgressql. I have tried jdbc connectivity in azure data bricks.I can able to insert and read data from delta lake to postgressql. But not able to achieve atomicity (to…
naresh t
  • 11
  • 1
1
vote
2 answers

How to access Azure AD integrated Postgres DB using Spring Data JPA?

We are having a PostgreSQL single service instance running in Azure, which is Azure AD integrated. So to connect via psql I follow this steps: Log in via az login Retrieve access token $env:PGPASSWORD=$(az account get-access-token --resource-type…
Matthias Güntert
  • 4,013
  • 6
  • 41
  • 89
1
vote
1 answer

EF Core + Azure PostgreSQL with Managed Identity Documentation?

MS has documentation for EF Core + Azure SQL with Managed Identity. This SO post from two years ago also had an in-depth discussion regarding it along with some alternative implementations. But I cannot find anything for Azure PostgreSQL, which also…
thankyoussd
  • 1,875
  • 1
  • 18
  • 39
1
vote
1 answer

Azure postgres database private connection between subnet

I try to connect a application who is in a subnet sub_A to a postgresql database that have a private endpoint in the subnet sub_B and still fail to do it. I do a lot of try and i am able to connect in the database from a VM in sub_B so i expect that…
quentin ledoux
  • 11
  • 2
1
vote
1 answer

Configuring Azure PostgreSQL in Gitlab EE

I am searching for some help in how to configure Azure PostgreSQL DB in a Docker Swarm based Gitlab instance. Initially, I followed the documentation in https://docs.gitlab.com/13.6/ee/administration/postgresql/external.html. Yet I came to find out…
hgpestana
  • 409
  • 1
  • 4
  • 11
1
vote
1 answer

How to save files from postgreSQL to local?

I have a requirement that there are a lot of files (such as image, .csv) saved in a table hosted in Azure PostgreSQL. Files are saved as binary data type. Is it possible extract them directly to local file system by SQL query? I am using python as…
SQL BIGNNER
  • 53
  • 3
1
vote
1 answer

How to authenticate Azure PostgreSQL with token retrieved from Azure AD with username & password?

I have used the documentation at https://learn.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication to enable users in Azure AD to authenticate to an Azure PostgreSQL instance using a token. I would like for users of a…
Gene McCulley
  • 1,097
  • 1
  • 10
  • 15
1 2 3
…
11 12