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
0
votes
1 answer

Azure Database for PostgreSQL Flexible Server: pg_restore produces pg_catalog ACL privilege warnings

I am using Azure DevOps Pipelines in order to copy databases from one Azure Database for PostgreSQL Flexible Server (in my prod environment) to another Azure Database for PostgreSQL Flexible Server (in my testing environment) by means of pg_dump and…
Joerg
  • 790
  • 2
  • 10
  • 23
0
votes
0 answers

Azure - WebApp + Database - How to deploy the db-schema and data

We are using this template from Azure. DB used is "postgresql flexible-server" as DB from web app, we can connect to DB. What is the best practice to deploy and execute DB/Table schema script on database server as one time process ? E.g. using some…
Banng
  • 531
  • 1
  • 6
  • 19
0
votes
0 answers

psycopg2 fetch record hangs

I have a kubernete microservice that can access Postgres, both in Azure. If I run the microservice container in my local and access the same Postgres in Azure, it has no problem. But if run the same container in AKS vm, the fetchall just hangs for…
thsieh
  • 620
  • 8
  • 24
0
votes
1 answer

How to restore local PostgreSQL database backup to Azure PostgreSQL server?

I have a question of how we can restore a local database backup in Azure PostgreSQL server?
Gudwlk
  • 1,177
  • 11
  • 11
0
votes
1 answer

PostgreSQL: Import database dump (.sql) in Azure Space such as Azure Function, Azure Data Factory, ETC

I have a GB PostgreSQL database dump. I need to import it into an Azure postgreSQL single server. I know the below command but I prefer the import done inside DB without command line in the hosting OS environment. psql -U postgres -d mydatabase -f…
Aussie
  • 83
  • 1
  • 10
0
votes
1 answer

Scaling Azure Postgres: Specified Availability Zone not supported in this region

I try to scale (provide more Cores) to my Azure Postgres DB (Flexible Server). No matter which size I choose, I always get the same error: "Specified Availability Zone not supported in this region." The DB is deployed to Sweden Central. According to…
msts1906
  • 89
  • 1
  • 11
0
votes
1 answer

Spring Boot (Spring JPA) app connects to Azure PostgrestSQL on local but not on Azure App Service

All I did was follow the instructions on this Microsoft tutorial about Using Spring JPA with Azure Database for PostgreSQL. I followed the tutorial step-by-step. It did work on local, but once I tried deploying to Azure App Service using the…
dg713
  • 3
  • 4
0
votes
2 answers

SSL connection is required. Please specify SSL options and retry - postgresql using dbforge

I have enabled Azure Postgresql SSL connection mode and after doing that I was not able to connect to Postgres database using dbForge, it is showing that SSL connection is required. Please specify SSL options and retry. I can able to access the…
Abhishek Hotte
  • 21
  • 9
0
votes
1 answer

terraform azure install extension via terraform or gitlab CI

Azure postgre sql can be installed via terraform(git lab CI). But how to configure extension. At the moment we are doing this manually. For instance, application teams that have functionality that needs encryption can enable pg_crypto by using the…
Blue Clouds
  • 7,295
  • 4
  • 71
  • 112
0
votes
1 answer

Implement Oracle external table like functionality in Azure managed postgresql

Currently we are using Oracle 19c external table functionality on-prem whereby CSV files are loaded to a specific location on DB server and they get automatically loaded into an oracle external table. The file location is mentioned as part of the…
Jacob
  • 426
  • 3
  • 19
0
votes
2 answers

Azure Postgres Single server version upgrade

Azure Postgres Single server version is 11. Is it possible to upgrade it to 13+ version using dump and restore as mentioned here: https://learn.microsoft.com/en-us/azure/postgresql/how-to-upgrade-using-dump-and-restore It should still remain Single…
Blue Clouds
  • 7,295
  • 4
  • 71
  • 112
0
votes
1 answer

Setting up Azure Postgre SQL environment variables causing issue in connecting database from PGAdmin

I am using an open source platform to customize my application which runs using postgre SQL. From local it is working fine and when I try to connect with Azure Postgre SQL it is asking for some security keys and those are not available. My main…
user235
  • 1
  • 5
0
votes
1 answer

update local Dockerized Postgress DB from an equivalent DB on Azure

I have an un-updated local Postgres server, running on a docker container, now I want to update all new records from Production DB, which runs on Azure Postgres DB. I'm aware of the pg_dump as in this Answer but, I'm not clear where should I commend…
RSNboim
  • 130
  • 1
  • 8
0
votes
0 answers

Error changing owner in Azure Postgres with superadmin

I hope anyone can tell me what I am doing wrong here. I have upgraded an Azure Postgres PaaS database from version 10 to 11. I've just followed the Microsoft guide for doing the upgrade. All went fine and after recreating the private endpoints, I…
Roberto Hernandez
  • 8,231
  • 3
  • 14
  • 43
0
votes
1 answer

Near zero downtime deployment with Azure Managed PostgreSQL

Is it possible to support near zero downtime deployment with Azure managed PostgreSQL (either Single Server or Flexible Server)? If yes, could you please advise the best practices to implement such a set up in both single server and flexible server…
Jacob
  • 426
  • 3
  • 19
1 2 3
…
11 12