"Azure Database for PostgreSQL" is PostgreSQL as-a-service in MS Azure. Use this tag specifically for the azure service "Azure Database for PostgreSQL". DON'T use it for PostgreSQL hosted on a Azure virtual machine.
Questions tagged [azure-database-postgresql]
38 questions
43
votes
8 answers
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. Please specify SSL options and retry.
Is this a…
Shantanu
- 2,871
- 4
- 24
- 38
11
votes
3 answers
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 specified. Please check the Username and retry…
Shantanu
- 2,871
- 4
- 24
- 38
10
votes
2 answers
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 database (or at least it seems like the database…
Gunnis
- 193
- 1
- 8
6
votes
2 answers
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 PostgreSQL database (PaaS), but the user it creats is…
Saulo Tapia
- 63
- 1
- 4
5
votes
1 answer
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 ".control.database.windows.net" (and 7 other names) does not match host name…
Shantanu
- 2,871
- 4
- 24
- 38
4
votes
1 answer
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 backup user:
ALTER TABLE jobschedule.jobs ENABLE ROW…
Ollie
- 1,140
- 8
- 26
3
votes
1 answer
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 an Azure managed PostgreSQL DB instance. The…
Marcel
- 41
- 5
3
votes
2 answers
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 postgres HBA (this is the thing Azure calls a…
yungchin
- 1,519
- 2
- 15
- 17
3
votes
1 answer
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 portal to the effect and can also view the server…
Shantanu
- 2,871
- 4
- 24
- 38
3
votes
2 answers
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?
Eric_Zhang
- 85
- 5
2
votes
2 answers
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 issue somewhere...
Update. I've discovered I can…
DamonJW
- 3,342
- 2
- 24
- 29
1
vote
1 answer
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.
"sku": {"name": "Standard_B1ms","tier":…
Kenny_I
- 2,001
- 5
- 40
- 94
1
vote
0 answers
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 application for ADC:
When I have no Npgsql version…
Peter Horniak
- 123
- 5
1
vote
1 answer
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
.
.
.
tags = { test = "test" }
And error…
Phatter
- 23
- 2
- 7
1
vote
1 answer
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 run Docker. I am running a container for RStudio…
Doug Fir
- 19,971
- 47
- 169
- 299