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.
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 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…
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…
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?
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:…
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…
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 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.…
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…
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…
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…
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
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 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…
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…
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…
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…
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…
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…