Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,172 questions
1 answer
troubles with connection to postgresql database using power bi
today I faces the issue with conneciton to my database sotred in the Azure PostgreSQL Flexible Server, but only from Power BI, during connection attempt I receive the error message ' No user nor password did not change, using different tools e.g.…
asked 2024-09-17T18:22:16.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 28.000000000000004%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Konrad Wawrzyniec
0
Reputation points
edited the question 2025-01-27T04:55:18.7666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rakesh Gurram
11,475
Reputation points Microsoft Vendor
1 answer
Feasibility of Direct Switching High Availability Mode from Same Zone to Zone-Redundant in Azure PostgreSQL Flexible Server
Hi, Can the high availability configuration for an Azure PostgreSQL Flexible Server be changed directly from same zone to a zone-redundant setup ? If so, would there be any impact? Also, is there any documentation stating that this is possible ?
asked 2025-01-26T18:20:52.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
$@chin
135
Reputation points
answered 2025-01-27T04:13:02.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,425
Reputation points Microsoft Vendor
2 answers
is there plan to support pgvector 0.8.0 version?
Currently PostfeSQL 16 supports pgvector 0.7.0, however version 0.8.0 introduced a significant improvement to hybrid search and it would be great to have it. Is there a plan to support it and what would be the timeline?
asked 2025-01-24T06:34:23.9833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 36%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Marko Simic
0
Reputation points
commented 2025-01-27T02:55:23.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,915
Reputation points Microsoft Vendor
3 answers
how to upgrade PostgreSQL client in azure cloud shell
Hi, I have run the below command and getting below error. pg_dump -Fc -v --host=XXXXXXX --username=XXXXX --dbname=XXX -f test_dev_flexi_psqllogtim.dump Password: pg_dump: error: server version: 15.7; pg_dump version: 14.13 pg_dump: error: aborting…
asked 2025-01-22T09:55:35.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 19%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
S, P1686MS (623-WIPRO LIMITED)
0
Reputation points
commented 2025-01-27T02:54:16.65+00:00
Sai Raghunadh M
1,915
Reputation points Microsoft Vendor
0 answers
Connection with managed identity to postgresql and token expiration
Hello community, I have a Nest.Js app with TypeORM and PostgreSQL.I want to deploy my app to the azure and to connect the azure PostgreSQL database.I implemented next connection: Database module: import { Module } from '@nestjs/common'; import {…
asked 2025-01-22T10:35:50.8366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 2%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vasile
0
Reputation points
commented 2025-01-27T02:49:49.89+00:00
Sai Raghunadh M
1,915
Reputation points Microsoft Vendor
1 answer
Is HA for burstable tier of Azure postgres flexible server
Hi, The Azure documentation states that HA is supported for PostgreSQL Flexible Server if the regions have zone support. However, for the burstable tier, I do not have the option to enable HA while creating the cluster, even though it is supported for…
asked 2025-01-22T10:15:48.1333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 96%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nikhil M
0
Reputation points
commented 2025-01-24T09:12:14.3966667+00:00
Sai Raghunadh M
1,915
Reputation points Microsoft Vendor
2 answers
Why does the major version update fail when postgis is installed
The serverlogs show the following error when doing a major version upgrade from postgres version 14 to version 16. Installed postgis, postgis_raster and postgis_sfcgal. ERROR 0A000 SELECT…
asked 2025-01-12T13:06:16.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 8%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Richard Huesken
1
Reputation point
commented 2025-01-24T04:26:29.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,171
Reputation points
1 answer
One of the answers was accepted by the question author.
When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?
When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?
asked 2024-05-10T14:05:27.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cooling, Steve
20
Reputation points
commented 2025-01-23T17:34:06.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rico Fritzsche
0
Reputation points
1 answer
Azure DB for PostgreSQL Migration Move Public IP Address
Need to migrate an existing Azure Database for PostgreSQL - Single Server over to Azure Database for PostgreSQL - Flexible Server. The single server has a standard azure "Public (FQDN) address" of xxxxx.postgres.database.azure.com. How can…
asked 2025-01-21T21:28:24.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 51%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVI%3C/text%3E%3C/svg%3E)
Vision Intelligence
60
Reputation points
edited a comment 2025-01-23T11:49:39.3366667+00:00
Vision Intelligence
60
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure DB for PostgreSQL Migration Offline vs Online
In my existing Azure Database for PostgreSQL - Single Server instance, I have three databases.....(MyDB1, MyDB2, and MyDB3). The migration service allows me to pick online mode or offline mode for the migration, and which databases I wish to migrate. …
asked 2025-01-22T14:35:12.7366667+00:00
Vision Intelligence
60
Reputation points
commented 2025-01-23T10:13:59.9033333+00:00
Vision Intelligence
60
Reputation points
0 answers
User Entra authentication to Postgres flexible server
When using EntraID authentication is the only option for users the token based authentication flow descibed here? Our users now have to obtain a new token every hour when working with tools like PowerBI.
asked 2025-01-22T13:17:41.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 26%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Peter Koller
45
Reputation points
commented 2025-01-23T09:04:15.7633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
985
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
I want to migrate azure database for postgresql single server to flexible, any suggestions or checks and process that i need to follow
I have azure database for postgresql single server in production setup but not in pre production. Now I want to migrate it to flexible server. What process is best to do it and what things should i keep in mind
asked 2025-01-22T05:32:03.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 72%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ihtisham Mushtaq
25
Reputation points
accepted 2025-01-23T08:44:55.37+00:00
Ihtisham Mushtaq
25
Reputation points
1 answer
Unable to use function schedule_in_database using azure_pg_admin
Dear Azure community, We have recently subscribed to Azure PostgreSQL 16 from SAP BTP for Production instance. However, we have not been able to use cron function "schedule_in_database" to schedule jobs. We are facing the below permission…
asked 2025-01-07T04:55:54.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 39%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Choppakatla, Sasi Kiran
0
Reputation points
answered 2025-01-23T05:52:33.77+00:00
ShaktiSingh-MSFT
16,171
Reputation points
1 answer
Can't create tables in Flexible PostgreSQL, even with CTc privileges
Hi there, I'm not able to create tables in a PostgreSQL database I created myself, even though I've given the user all privileges to the database ("CTc"). Here are the privileges (notice the "metabase" role/user): metabase=> \l …
asked 2025-01-20T20:16:31.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 42%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Diogo Baeder
0
Reputation points
commented 2025-01-22T22:55:10.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
2,095
Reputation points Microsoft Vendor
2 answers
permission denied for schema _timescaledb_internal on Azure PostgreSQL flexible server
I tried to migrate db from Azure PostgreSQL single server to flexible server using migration tool from Azure portal. But there is an error on validation check because migration tool doesn't support timescaledb extension. Portal message said that…
asked 2024-04-17T11:08:26.95+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 21%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michiteru Sugitani
80
Reputation points
commented 2025-01-22T18:13:28.8066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 36%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Ryan Rohm
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Azure Database for PostgreSQL - Flexible Server Stuck in Stopping State
The Azure Database for PostgreSQL instance…
asked 2025-01-20T16:21:13.1066667+00:00
Jacopo Spolverati
20
Reputation points
accepted 2025-01-22T08:28:14.8+00:00
Jacopo Spolverati
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Permission denied for sequence jobid_seq when trying to do a pg_dump
Hi! I am trying to perform a backup of my database in Azure Database for PostgreSQL flexible server into my machine. I have tried using pg_dump and also doing a backup through the pgAdmin client, however, in both cases I get the same error: …
asked 2022-09-30T22:32:49.997+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
giovanni
21
Reputation points
answered 2025-01-22T03:35:11.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Danton Heuer
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure database for Postgres Flexible server - Why creating extension uuid-ossp requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server (version PG16). I tried to create extension on current database (logged into database as db owner) however I see an error stating "ERROR: Only members of…
asked 2024-10-30T10:51:45.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tulsiraja Shastry
20
Reputation points
answered 2025-01-22T01:22:10.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 94%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rowan M
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure DB Single Server Public IP migration options
For Azure Database for PostgreSQL Single Server...The migration process needs to be performed to move it to the Flexible Server service. Supported network scenarios for migration are discussed here... …
asked 2025-01-07T17:15:54.6866667+00:00
Vision Intelligence
60
Reputation points
accepted 2025-01-21T19:21:17.12+00:00
Vision Intelligence
60
Reputation points
0 answers
Azure Database for PostgreSQL - Flexible Server is taking too long to initialize
When trying to create a Azure Database for PostgreSQL - Flexible Server. It is taking too much time to initialize. I tried to create it with a basic spec and even tried changing the region. But it is stuck in the initialization process.
asked 2025-01-13T12:05:49.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Adish M
5
Reputation points
commented 2025-01-21T18:08:24.2666667+00:00
Oury Ba-MSFT
20,176
Reputation points Microsoft Employee