825 questions with Azure Database for PostgreSQL tags

Sort by: Updated
3 answers

Upgrading Azure Database for PostgreSQL flexible server to version 16

When trying to upgrade a PostgreSQL server from 15 to 16 I'm getting the following error: You are already running the latest major PostgreSQL version available. It is possible to create a new Azure Database for PostgreSQL flexible server with version 16.

Azure Database for PostgreSQL
asked 2024-01-04T09:53:45.2533333+00:00
Jonas Kvinge 15 Reputation points
commented 2024-02-07T14:23:58.9333333+00:00
Marius Løkken 0 Reputation points
2 answers

ERROR: postgresql Connection terminated due to connection timeout

Getting an error as ERROR: postgresql Connection terminated due to connection timeout pool = new Pool({ max: 300, connectionTimeoutMillis: 5000, host: 'c-abxxxfg.22ps25nxx7gjw5.postgres.cosmos.azure.com', …

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
697 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,401 questions
Azure Database for PostgreSQL
asked 2024-02-06T09:44:47.8433333+00:00
Akash Panda 0 Reputation points
answered 2024-02-07T10:36:49.04+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
1 answer

Azure Database for PostgreSQL Flexible Server

Hello Team, My query is more concerned with Azure Database for PostgreSQL Flexible Server. Recently I had raised a ticket requesting to get the Region access with zonal dependency (Availability Zones) for my subscription. Support quickly got the…

Azure Database for PostgreSQL
asked 2024-02-02T14:02:46.03+00:00
Learn Cloud 80 Reputation points
commented 2024-02-06T21:10:33.6333333+00:00
Oury Ba-MSFT 15,821 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Can't Find Firewall Settings for PostgreSQL Flexible Server

I created a Web App + Database and am having problems connecting to the PostgreSQL server using PgAdmin and Azure CLI. All the instructions I'm finding to add my IP address seem to indicate a Firewall setting that I am having a hard time finding. Is…

Azure Database for PostgreSQL
asked 2024-02-05T17:57:19.76+00:00
coding_took 20 Reputation points
answered 2024-02-05T23:01:01.6433333+00:00
Oury Ba-MSFT 15,821 Reputation points Microsoft Employee
1 answer

orafce extension in Azure Database for PostgreSQL flexible server

orafce extension is not supported in Azure Database for PostgreSQL flexible server with PostgreSQL version 16, is there any alternative for this?

Azure Database for PostgreSQL
asked 2024-01-31T07:31:54.8566667+00:00
answered 2024-02-05T04:30:45.9266667+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
3 answers

Anon extension is not loading in postgresql flexible server version 15.3

I am trying to load "anon" extension for postgresql flexible server (15.3) . ( for "anon" referring this https://postgresql-anonymizer.readthedocs.io/en/latest/ ) however I always get this error . SQL Error [22023]: ERROR:…

Azure Database for PostgreSQL
asked 2023-09-18T11:34:32.89+00:00
Prasad Patil 5 Reputation points
commented 2024-02-03T15:19:40.4466667+00:00
Andrei Chiriaev 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can't filter on both (tagName/tagValue) and resourceType

I have a problem where I am trying to discover services on my subscription via the Azure REST service "Resource Management". I am trying to list resources of a certain type, that fit a certain criteria, where I want to specify a tag as…

Azure Database for PostgreSQL
asked 2024-02-01T12:40:02.77+00:00
Christoffer Pedersen 20 Reputation points
edited the question 2024-02-02T05:02:09.3466667+00:00
PRADEEPCHEEKATLA-MSFT 75,131 Reputation points Microsoft Employee
3 answers

Offline Migration to postgreSQL flexible server failes with extension creation error

Migrating my PostgreSQL Single Server to Flexible Server does not work. The error message is as follows: One or more errors occurred while migrating 'xxx' : EX001: Extension creation failed for the following extensions: hypopg, pg_buffercache,…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-01-27T09:39:10.4766667+00:00
Wolfgang Roese 0 Reputation points
commented 2024-02-01T17:58:19.88+00:00
Oury Ba-MSFT 15,821 Reputation points Microsoft Employee
4 answers

Azure postgreSQL single server publisher to subscriber replication new slot not getting active.

Hi Experts, Azure PostgreSQL single server is the publisher, and the subscriber is an Azure VM running PostgreSQL. There are already 10 replication slots that are working properly; however, when we tried to create 11 slots, they did not become active.…

Azure Database for PostgreSQL
asked 2024-02-01T02:13:22.54+00:00
Veera 180 Reputation points
answered 2024-02-01T08:31:30.0733333+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
2 answers

Cannot access Azure Postgres DB from outside Vnet, Further assistance required on Power BI report embedding using this DB as source data.

We have an Postgres flexible server and this database cannot be accessed from outside the vnet and there does not seem to be an option to enable it now. If we wanted to use this data on Power BI desktop to create reports, how do we do this without a…

Azure Database for PostgreSQL
asked 2024-01-31T07:52:34.2366667+00:00
Sai Skanda 0 Reputation points
answered 2024-02-01T06:25:08.96+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
4 answers

Problem with pg_dumpall in PostgreSQL Flexible Server

I have an Azure Database for PostgreSQL flexible server (version 12). I'm trying to upgrade using the official docs (the goal is to upgrade to 14). The first step is to dump the roles pg_dumpall -r --host=mySourceServer --port=5432 --username=myUser…

Azure Database for PostgreSQL
asked 2023-02-10T02:16:00.56+00:00
Artur Drobinskiy 0 Reputation points
edited an answer 2024-01-31T09:47:31.02+00:00
Lucas Bouvy 0 Reputation points
2 answers

what is the difference between vacuum and full vacuum in postgresql

In the real time environment, what is the difference between vacuum and full vacuum in Azure Database for PostgreSQL flexible server? Also, is it possible to turn on Auto vacuum in the night? so that it can take care of itself by morning, that would be…

Azure Database for PostgreSQL
asked 2024-01-27T17:39:44.0366667+00:00
commented 2024-01-31T06:34:59.52+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
1 answer

How to create ttl job in Azure db for postgresql?

Hi, I need to create a TTL in Azure db for postgresql single server, that doesn't have pg_cron. Is there any possibility to set up ttl? Thank you

Azure Database for PostgreSQL
asked 2024-01-26T11:04:54.1533333+00:00
SZ-6622 0 Reputation points
accepted 2024-01-30T13:38:50.0433333+00:00
SZ-6622 0 Reputation points
2 answers

Not possible to move specific Azure resource to specific region

I created a resources (network, static web app, web-service...) in Azure west Europe region. When But when I tried to create a Azure Database for PostgreSQL flexible server resource, it was not possible to create it in West Europe. I tried several…

Azure Database for PostgreSQL
asked 2024-01-29T19:58:04.53+00:00
Winking - admin 0 Reputation points
answered 2024-01-30T13:24:47.6066667+00:00
Rahul Randive 7,471 Reputation points Microsoft Employee
1 answer

Azure reservations - what products are similar when exchanging?

Hi, On this page - you mention some examples of similar and dissimilar products when it comes to reservations. For example, you mention that "...you can't exchange dissimilar reservations. For example, you can't exchange an Azure Cosmos DB…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,401 questions
Azure Database for PostgreSQL
asked 2024-01-15T08:16:07.68+00:00
Joel Sundström 0 Reputation points
commented 2024-01-30T08:58:27.79+00:00
TP 71,761 Reputation points
2 answers

Can't drop postgresql flexible server database with logical replication

Help please resolve the issue with broken database. The problem: Have not responding database on server In pg_catalog.pg_subscription old subscription record to this database And now I can't delete subscription from pg_subscription…

Azure Database for PostgreSQL
asked 2024-01-23T10:26:30.5333333+00:00
Yury 0 Reputation points
commented 2024-01-30T05:53:04.91+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

How to fix a Can't reach database server at `.postgres.database.azure.com`:`5432` error

hey am getting an error when querying the postgre flexible database below is the error { "errors": [ { "message": "\nInvalid prisma.users.create() invocation:\n\n\nCan't reach database server at…

Azure Database for PostgreSQL
asked 2024-01-22T12:37:47.23+00:00
Philip Mutuku 20 Reputation points
accepted 2024-01-29T22:50:14.7666667+00:00
Philip Mutuku 20 Reputation points
1 answer One of the answers was accepted by the question author.

Does scaling PostgresSQL Performance Tier comes with a downtime?

Does changing the "Performance Tier (Preview)" come with a restart/downtime of a database? Is it safe to do so during business hours as we need to immediately increase the performance of our database? Thank…

Azure Database for PostgreSQL
asked 2024-01-22T11:43:13.8833333+00:00
Ladislav Gallay 141 Reputation points
commented 2024-01-29T18:54:57.27+00:00
Rahul Randive 7,471 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

I cannot promote Postgres 15 to Postgres 16 despite it being generally available

Based on this documentation https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-supported-versions#postgresql-version-16 Postgres 16 is generally available. I have this instance…

Azure Database for PostgreSQL
asked 2024-01-05T19:50:11.2266667+00:00
Ladislav Gallay 141 Reputation points
commented 2024-01-29T08:58:59.93+00:00
Sela Goldenberg 11 Reputation points
1 answer One of the answers was accepted by the question author.

Move Region for PostgreSQL Flexible Server

I have a PostgreSQL Flexible Server. When I use the Azure Resource Mover, my server doesn't show on the list. Per the docs I can move a PostgreSQL Single Server, but I didn't see an entry for flexible server. Is it impossible to move a flexible…

Azure Database for PostgreSQL
asked 2022-06-21T16:27:26.343+00:00
Joshua von Damm 26 Reputation points
commented 2024-01-26T18:38:29.6533333+00:00
ROJAS CHACON Gonzalo ACID LABS 0 Reputation points