48 questions
0
votes
1
answer
2k
views
Cannot grant permission to EntraId user: WARNING: no privileges were granted for "My-Postgres-Database" after
I've created Azure Database for Postgres Flexible Server with "DbAdmins" group as Microsoft Entra Administrator
I need to add EntraId user and as a regular user with limited priviledges to '...
- 27.8k
2
votes
1
answer
627
views
Why can't I login to Azure Database for Postgres, when I'm member of admin group
I've assigned a Group (Microsoft Entra) as Postgres server admin.
I'm member of the group.
I'm able to access the DB with groupname as user:
$ ACCESSTOKEN="$(az account get-access-token --...
- 27.8k
0
votes
2
answers
2k
views
Managed identity in Azure Database for Postgres
I'm a little confused on what exactly is required in order to be able to login to Azure Database using Microsoft EntraId Identity resp. Service Principal.
There are different articles:
This one says ...
- 27.8k
0
votes
0
answers
44
views
Create SQL DB user without exposing database during IaC depoyment
I have and Azure DevOps CD pipeline, that deploys Azure Infrastructure (using Pulumi).
It creates and Azure Database for PostgreSQL.
I want to create SQL User (other than existing superadmin) in ...
- 27.8k
0
votes
1
answer
1k
views
Connect/Deploy to Azure Database for PostgreSQL Flexible Server with Service Connection
I am trying to connect and update databases in an Azure Database for PostgreSQL Flexible Server during my release pipeline in Azure DevOps. However due to the security restrictions within my ...
- 755
2
votes
1
answer
558
views
PostgreSQL deployment via ARM template failing due to too many configuration changes
I'm trying to deploy a PostgreSQL database via ARM template, along with around 33 config changes during deployment. Some of the configurations are updated but the rest fail with
'<server>' is ...
- 83
0
votes
1
answer
457
views
Cannot connect Azure DB for PostgreSQL from Dataflow in ADF
I want to insert data into and update a table in Azure DB for PostgreSQL using Data flow in ADF. But I cannot create connection between data flow and DB due to a network error.
Because of company ...
user19504539
0
votes
1
answer
458
views
Nodejs - Can't connect to Azure database with sequelize and pg - no pg_hba.conf entry for host
I have got an issue when trying to connect Azure postgres database from Nodejs app. Connecting by sequelize and pg lib give me same issue "no pg_hba.conf entry for host". After looking ...
- 11
0
votes
1
answer
469
views
Azure DB for Postgres not accessible from Azure App Services
I'm running a Dotnet Web API in a container on Azure App Services (Free tier plan).
In my application, I check the POSTGRES_CONN_STRING environment variable and then use it as a connection string for ...
- 982
0
votes
1
answer
335
views
Access Azure App Service Database from local machine
I'm trying to access Azure App Service Database (Postgress)from a client tool install in my local machine. But still I could not figure-out how to do this.
Can some one please help on this ?
Thanks.
- 648
0
votes
2
answers
2k
views
SqlAlchemy connect to Azure Postgresql Flexible Database with token authentication
I would want to connect SqlAlchemy to Azure Database for Postgres with token based authentication to achieve Single Sign On (SSO) by using Azure Active Directory (AAD), but seems like SqlAlchemy ...
- 93
1
vote
0
answers
2k
views
Copy production DB from one Azure Database for PostgreSQL Single Server to another one in a lower environment
I was working on a project in which customer is asking us to copy a production DB (87 GB) from a production Azure Database for PostgreSQL Single Server (version 11) to another one in pre-production ...
- 11
0
votes
2
answers
2k
views
Connecting to an Azure Database for PostgreSQL flexible server from an Azure Function serverless
I have an Azure Function that connects to an Azure Database for PostgreSQL flexible server, but I am getting a timeout (while from my local I can do it without any problem). After some research, I ...
- 384
1
vote
1
answer
2k
views
PGBouncer-Azure Database for PostgreSQL Flexible Server
I created a new database in Flexible Server and enabled the pgbouncer. When I run SHOW DATABASE, it only displays two databases. How to assign a newly created database to pgbouncer.please find the ...
- 13
2
votes
1
answer
2k
views
Azure Microsoft.DBforPostgreSQL flexibleServers database collations
I tried to create new database with different (than en_US.utf8) collation on Azure Microsoft.DBforPostgreSQL flexibleServers. CLI and Bicep gives "Internal Server Error" as a message and ...
- 61