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
8
votes
3 answers

Node is 20x faster Than .NET Core in Connecting to Postgres

I have two servers connecting to a PostgresSQL 9.6 db hosted on Azure. The servers are doing one thing - hitting the Postgres db with a SELECT 1 query every 5 seconds. Typical time to connect to db and get data: Node: 25 MS .NET Core 3.1 using…
VSO
  • 11,546
  • 25
  • 99
  • 187
5
votes
2 answers

ADF-Postgres Timeout

I'm working with ADF and Azure Managed Postgres. I've had a reoccurring issue with look-ups and query-sourced copy activities timing out after about 35 seconds. Failure happened on 'Source' side. 'Type=Npgsql.NpgsqlException,Message=Exception while…
Robert Riley
  • 389
  • 1
  • 7
  • 31
4
votes
4 answers

How can i connect Azure postgres database to pgadmin as im getting time out error

I have created a database in Azure database in postgreSQL but when i try connect through pgadmin it says unable to connect timeout expired(I'm pretty sure admin and password are correct). Is anyone facing this issue? is there an alternative for…
Jordan Mong
  • 55
  • 1
  • 7
4
votes
1 answer

Remove the @ from azure postgresql username

When creating a new postgresql instance on the azure portal or even the CLI, the username is automatically made to be like user@databasename so i can't use it on a database string, funny enough Azure has an entire section with connection strings,…
Guillermo Siliceo Trueba
  • 4,251
  • 5
  • 34
  • 47
3
votes
1 answer

Azure ConnectionStrings feature not working with ASP.NET app

I am totally new to using Azure services. I've been trying to deploy a C# / ASP.NET Core 7 app I created that relies on Postgres as the database and Entity Framework as ORM. I used App Services (Linux) to deploy my app from a GitHub Action and the…
kittyyy
  • 56
  • 4
3
votes
3 answers

azure + postgresql: How to fix error: Unable to connect to server: server closed the connection unexpectedly

i use postgresql server in azure. Until few hours ago I was able to access the server from pgAdmin 4 but now I get the following error: ' Unable to connect to server: server closed the connection unexpectedly This probably means the server…
user2993539
  • 375
  • 1
  • 3
  • 14
3
votes
1 answer

Long connection time with Azure Postgres

I have Azure Database for PostgreSQL service (PaaS). When I'm trying to query it with psql then even simple SELECT query from one table takes ~1.5s. When I'm in postgres console then there is no issue, queries execute under 100ms. What can cause…
sobi3ch
  • 2,555
  • 2
  • 31
  • 41
3
votes
1 answer

How to resolve `SSL SYSCALL Error` with a PostgreSQL Database on Azure?

After restarting my PostgreSQL on Azure Database Instance, I can no longer connect via any client and I receive: psql: SSL SYSCALL error: EOF detected with psql. I used the Restart button on the Azure Database for PostgreSQL server overview page.
Jay Cummins
  • 1,039
  • 2
  • 14
  • 31
2
votes
3 answers

Identify Azure Private DNS Zone entry for Azure Database for PostgreSQL flexible server

I set up an Azure Database for PostgreSQL flexible server instance with private access (VNet Integration). It is mandatory to provide a Private DNS Zone which I did. After successfully creating the instance you can find a record inside that Private…
cmoetzing
  • 742
  • 3
  • 16
2
votes
2 answers

Django Rest Framework very slow on Azure

I had migrated from Heroku to Microsft Azure, and the speed is really very slow, my App service is having the following specs OS (linux): P1V2 210 total ACU 3.5 GB memory Dv2-Series compute equivalent then when it comes to my Azure Database for…
Lutaaya Huzaifah Idris
  • 3,596
  • 8
  • 38
  • 77
2
votes
0 answers

Azure Database for PostgreSQL - Admin user access issue

I have created new Azure database for PostgreSQL - Flexible Server with admin user as "admin_demo". Now after creating database I have done followoing steps: create schema abc authorization admin_demo; -- creates new schema. create role…
swapnil solanki
  • 76
  • 3
2
votes
0 answers

Postgres: Triggers causing deadlock

System: Postgres 13.4 on Azure Database for PostgreSQL flexible server I set up triggers to aggregate data for different products into one aggregation table each. There is also one trigger that adjusts the aggregation tables whenever a discount is…
riderinred
  • 53
  • 1
  • 6
2
votes
0 answers

Azure Postgres AUTOVACUM AND ANALYZE THRESHOLD - How to change it?

I am coming again with another Postgres question. We are using the Managed Service from Azure that uses autovacuum. Both vacuum and statistics are automatic. The problem I am getting is that for a specific query, when it is running at specific…
Roberto Hernandez
  • 8,231
  • 3
  • 14
  • 43
2
votes
1 answer

psycopg2.OperationalError: could not translate host name "
" to address: Temporary failure in name resolution

I have looked through similar posts on SO and they seem to be specific to using Docker environments and haven't been much helpful. Ours is a little different, we do run a docker image of Airflow hosted on Azure App Service but it connects to hosted…
Vinay Kulkarni
  • 300
  • 1
  • 5
  • 13
2
votes
0 answers

Azure Database for Postgres Restore to point in time not working

I have an Azure Database for Postgres instance that I wanted to roll back a few hours to grab some rows that I'd deleted. Using these instructions I tried to roll back one hour, a few hours, and a few days, but in all cases I'm seeing that the new…
papakpmartin
  • 193
  • 9
1
2 3
…
11 12