48 questions
0
votes
1
answer
1k
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
502
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
1k
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
43
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
523
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
444
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
440
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
458
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
329
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
0
votes
1
answer
1k
views
Azure Database for PostgreSQL flexible server logs not working
I am trying to run logs for Azure Database for PostgreSQL flexible server, but I keep on getting this in the image below, what could be the solution?
- 4,040
0
votes
1
answer
1k
views
Azure PostgreSql ODBC connection error SSL SYSCALL error: Connection reset by peer (0x00002746/10054)
I am trying to create a odbc connection for a Azure PostgreSQL db. Currently getting the error SSL SYSCALL error: Connection reset by peer (0x00002746/10054). When I disable Enforce SSL Connection, on ...
- 161
0
votes
1
answer
86
views
How can you incorporate/sync specific table details from Azure database for Postgres into SQL Server?
It is for an asp.net core project following microservice architecture.
1
vote
1
answer
1k
views
How to create Microsoft.DBforPostgreSQL with Bicep?
I would like to create PostgreSQL for location based service needs.
I would install GIS extensions next.
I have created manually Azure Database for PostgreSQL flexible server to decide correct config.
...
- 2,561
0
votes
1
answer
259
views
Safely drop a user in Postgres
I am very new to Postgress security topic. I have used the following commands to create a user.
CREATE USER myuser WITH PASSWORD 'PASSWORD';
GRANT CONNECT ON DATABASE "MyDB" TO myuser;
GRANT ...
- 2,584
0
votes
2
answers
2k
views
Connect to Azure Database for PostgreSQL server with Prisma
I am looking for a way to connect my Next.js application with Azure Database for PostgreSQL server. Prisma seems to work well with Next.js but I can't figure connection string or if it is even ...
3
votes
1
answer
1k
views
Interrupted VACUUM FULL on Azure managed PostgreSQL service consumed huge amount of space. How do I recover it?
I have encountered a problem that has known solutions if you are hosting your own server, but I do not know how to resolve on an Azure managed PostgreSQL DB instance.
I was performing a VACUUM FULL on ...
- 41
0
votes
1
answer
559
views
Azure database for postgreSQL Flexible Server and Entity Framework Core shows accented spanish words incorrectly
I have created a Flexible Server (Azure database for postgreSQL), I am using pgadmin to connect to this database (Encoding UTF8), I have a table named skills, and using pgadmin shows the spanish words ...
- 623
2
votes
0
answers
817
views
Is there a Npgsql release that works with TLS 1.2 and Azure Data Catalog?
could you please advise how I can use Npgsql to enable Azure Data Catalog (ADC) to access an Azure Database for PostgreSQL Server using TLS >= 1.2?
I get the following error when I use the local ...
- 133
1
vote
1
answer
8k
views
Why can't add tags into terraform modules
I got some problem to provision with tags on Azure database for PostgreSQL services, My code be like
module "postgresql" {
source = "./modules/postgresql"
service = var.service
.
...
- 23
0
votes
1
answer
813
views
Azure postgresql data encryption at rest
All managed dB services on azure have data encryption at rest turned on by default( as per azure docs). How to see the status on it for Azure postgresql.? Right now when I do "az postgres server show -...
- 4,208
0
votes
0
answers
329
views
Azure DB for PostgreSQL - changes to log_line_prefix parameter not implemented
I have a General Purpose Single Server instance of Azure DB for PostgreSQL where I have installed the pgAudit plugin.
I am trying to add more data to the pgAudit session auditing entries by following ...
0
votes
1
answer
336
views
Azure Database for PostgreSQL fail to Point in time restore
I use Azure Database for PostgreSQL server I can't restore my server it give me the following error
The resource operation completed with terminal provisioning state The
user name conflict with ...
- 326
1
vote
1
answer
298
views
Does the fact I'm running a VM alter the whitelisting status of my regular ip address?
Our dev ops team have whitelisted my home ip address so that I can connect to our Postgres database on Azure. I am able to connect to our Azure database due to this.
Today I set up a VM in order to ...
- 21.5k
2
votes
2
answers
4k
views
Remote access to an Azure Postgres database
How can I connect to an Azure PostgreSQL database, from a remote machine?
Update 2. I can connect to the database from WSL/Ubuntu using sudo psql, but I can't using plain psql. So it's a permissions ...
- 3,742
0
votes
1
answer
4k
views
Azure Database for PostgreSQL server is displaying 100% CPU utilization
Azure Database for the PostgreSQL server is displaying 100% CPU utilization every day from 10 AM to 12 PM. The load on the server is minimal when this is happening. Did anyone face the same issue? ...
0
votes
1
answer
3k
views
Azure PostgreSQL: it is not possible to remove database through Azure CLI
I have created pipeline using Azure DevOps for Azure PostgreSQL database.
What actually pipeline do?
Connect to PostgreSQL;
Remove database db_test from PostgreSQL using Azure CLI;
az postgres db ...
- 518
1
vote
1
answer
11k
views
Azure_superuser account password for Postgresql database on Azure
I have provisioned Azure Database for Postgresql, I'm trying to execute copy command in c# Azure function to load data from csv file to the database.
It throws an error saying ERROR: must be ...
- 11
2
votes
1
answer
3k
views
How can I use a Azure Database for PostgreSQL in a Azure Logic App?
To simulate a device I want to use a Logic App to fill a Azure Database for PostgreSQL with test data.
I found the two connectors PostgreSQL and SQL server but unfortunately both don't work for me. ...
- 23
11
votes
2
answers
7k
views
How to analyze poor performance from Azure PostGreSQL-PaaS
I'm experiencing poor performance from Azure PostGreSQL-PaaS and need help with how to proceed.
I'm trying out Azure PostGreSQL-PaaS in a project. I'm experiencing an intolerable performance from the ...
- 203
0
votes
1
answer
1k
views
Autovacuum config on Azure Postgresql
I am trying to change some global settings below for auto-vacuum on an Azure Database for PostgreSQL instance.
select * from pg_settings where name like 'autovacuum%'
Say if I want to change the ...
- 501
0
votes
0
answers
211
views
Azure Database for PostgreSQL Basic Plan and Debugging
We are using Azure Database for PostgreSQL Basic Plan (vCore 2) for development environment.
When we try to debug our application from Visual Studio (EF PostgreSQL), we often get "Unknown message ...
- 328
5
votes
1
answer
2k
views
Azure PostgreSQL cant Assign BYPASSRLS to a ROLE
I am trying to create a role in Azure PostgreSQL that is allowed to bypass row level security so I can run backups which do not fail when row level security is enabled for all users apart from my ...
- 1,170
0
votes
1
answer
2k
views
Connect Stream Analytics to Azure Postgres - Possible?
Getting error messages. Seems this is not possible ?
message is :
The JSON provided in the request body is invalid. Property 'server' value 'postgres-mydatabase123.postgres.database.azure.com' is ...
- 443
1
vote
1
answer
976
views
How to create database template on azure postgresql service
While using the database service for postgresql om azure, it looks like it is not possible to create a custom template database.
What I want to achieve, is that a regular account, csn create new ...
- 371
7
votes
2
answers
16k
views
Can't create a PostgreSQL Superuser role to get an Application installed and running
I want to install an application (Odoo) that uses PostgreSQL, but it needs you create a superuser Role to allow the aplication process instalation create its own database. I just created an Azure ...
- 73
1
vote
4
answers
2k
views
API for Azure Database for MySQL
Azure Database for MySQL server is still in preview, though we can created database instance on it.
I wonder do we have any API to retrieve the databases that we created on Azure Database for MySQL ...
- 21
3
votes
2
answers
2k
views
From what source-IP range do outbound connections from Pods appear to come?
I want to set up connections from a kubernetes cluster (created via az acs create with mostly default settings) to an Azure Postgresql instance, and I'd like to know what source-IP range to enter in ...
- 1,599
5
votes
1
answer
3k
views
Connection to postgres server on Azure fails when I use "sslmode=verify-full"
When I select "sslmode=verify-full" when connecting to my postgres server in Azure, the connection fails with the following error:
server certificate for "<region>.control.database.windows.net"...
- 2,921
44
votes
8
answers
55k
views
Why does connection to my Postgres server in Azure fail if my app does not have SSL enabled?
I get a connection failure when I try to connect to my postgres server in Azure from my app/client, which does not have SSL enabled.
Unable to connect to server:
FATAL: SSL connection is required. ...
- 2,921
14
votes
3
answers
14k
views
Connection to Azure postgres server fails in spite of correct username
When trying to connect to my postgres server in Azure from psql client, I get the following error, even though I am using the correct username. How can I fix this?
psql: FATAL: Invalid Username ...
- 2,921
3
votes
1
answer
6k
views
Unable to connect to my newly created postgresql server in Azure
After creating a new server in the Azure Database for PostgreSQL service, I get the following error when trying to connect to it. The server has been created since I see a notification on the Azure ...
- 2,921
3
votes
2
answers
1k
views
How to connect to the Azure database for MySQL and PostgreSQL in JAVA
There're just two new Azure Services released， Azure Database for MySQL and PostgreSQL, As a Java developer I'm wondering how to connect to them, Shall the regular JDBC drivers still work?
- 85