Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,046 questions
0 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…
Azure
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,153 questions
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
asked 2025-01-12T13:06:16.08+00:00
Richard Huesken
1
Reputation point
1 answer
Unable to stop/restart PostgreSQL Flexible Server (CPU at 100%)
I have a Azure Database for PostgreSQL - Flexible Server with its CPU usage at 100% for the past weeks... In the same period, the storage usage has also significantly increased to 80-90% of its 64 GB capacity. I am unable to stop/restart the server via…
asked 2025-01-08T19:51:51.9966667+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(99.2, 61%, 19%)' 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)
Gia
1
Reputation point
answered 2025-01-11T14:03: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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive
10,066
Reputation points
0 answers
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
![](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
20
Reputation points
commented 2025-01-10T21:06:20.68+00:00
Vision Intelligence
20
Reputation points
2 answers
Azure Cosmos Postgresql issue with Role creation
Hi, We are using Azure Cosmos Postgresql DB and we are experiencing issues with Role creation. We created a role from console as well as az cli using below command - The command shows succeeded and the role is visible. However the same role is not…
asked 2024-08-23T08:53:50.2166667+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(70.4, 3%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vipal Mehta
40
Reputation points
commented 2025-01-10T17:14:52.0333333+00:00
Oury Ba-MSFT
19,991
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Postgre-SQL Flexible Server - pg_cron permissions issue
I am connecting to the postgres database with the psqladminun user who is a member of the azure_pg_admin role. I run the following: CREATE EXTENSION pg_cron; After that I go to schedule a job: SELECT cron.schedule_in_database('part_maint_TEST','0 * * *…
asked 2024-11-20T22:35:13.98+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, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Herman, Justin
35
Reputation points
commented 2025-01-10T14:22:18.88+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, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Eric Swiggum
0
Reputation points
0 answers
Does Azure support PostgreSQL version 16.6?
Hello, My project is currently using version 15.7 of PostgreSQL Flexible server. However, we need to do an update to fix the following security vulnerabilities: https://www.postgresql.org/support/security/CVE-2024-10976/ …
asked 2025-01-09T11:47:33.3033333+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(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Joana Pedroso
0
Reputation points
edited a comment 2025-01-10T11:24:26.0733333+00:00
Joana Pedroso
0
Reputation points
0 answers
PostgreSQL query to find the host name
HI Team, I am looking for a PostgreSQL command/query (not Azure CLI )that i can run in Azure PostgreSQL flexible server to get the server name. currently i can get this info using the below psql command "\conninfo", but this command works only…
asked 2025-01-10T03:46:57.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(227.2, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
105
Reputation points
edited a comment 2025-01-10T08:48:56.18+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,010
Reputation points Microsoft Vendor
1 answer
Missing all data in Monitoring Metrics for Azure Database for PostgreSQL - Flexible Server
Firstly, I have followed the instructions found in the following threads and nothing works: 1- https://learn.microsoft.com/en-us/answers/questions/2134061/azure-database-for-postgresql-metric-storage-perce 2-…
asked 2025-01-02T20:15:35.4833333+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(57.599999999999994, 20%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Greg Polanco
0
Reputation points
answered 2025-01-09T16:43:27.4+00:00
Greg Polanco
0
Reputation points
0 answers
Postgres Flexible Server 15.8 No Longer Supports ANY md5 Functionality
The 15.8 version of the server no longer supports md5 hashing. The 15.7 version allows us to call the MD5() function within the server. We DO NOT use this function for passwords or other security mechanisms. It is purely used to create a unique,…
asked 2024-10-16T19:27:38.1866667+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(108.80000000000001, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Carson
0
Reputation points
commented 2025-01-08T20:48:18.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(240, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Matthew Mckenzie
5
Reputation points
0 answers
Connection Refused from AKS cluster to Postgres Flex server
Hi All, I am getting connection refused error while connecting to Postgres Flex server from AKS Cluster pod. Same Postgres Flex server connection is working fine from PgAdmin. Can someone please help what could be wrong configuration from AKS…
asked 2024-12-31T11:49:47.77+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(246.4, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Shah, Apoorv-XT
0
Reputation points
commented 2025-01-08T07:40:31.3766667+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(300.8, 3%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sai Krishna Katakam
1,680
Reputation points Microsoft Vendor
1 answer
How can I connect to the Postgres Flexible server to Azure Web App on Virtual Network from a different region.
I have a Azure Postgres Flexible server hosted in SouthEast Asia and hosting the backend Azure Web App hosted on East US (Proximity to the Azure OpenAI models), here the Azure Web App is not able to connect to the Postgres Flexible server. I have created…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,153 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,036 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
506 questions
asked 2025-01-02T18:58:16.6733333+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(76.8, 8%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ashwin
0
Reputation points
commented 2025-01-08T00:37:37.06+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(304, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Laxman Reddy Revuri
1,525
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
![](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, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Can't renew reservation for Azure Database for PostgreSQL expiring
Presently still using Azure Database for PostgreSQL - Single Server. We have a reservation that expires near end of January (azuredb_postgresql_general_purpose_compute_gen5 - East US). When attempt to purchase another reservation, only Flexible Server…
asked 2025-01-06T13:46:39+00:00
Vision Intelligence
20
Reputation points
accepted 2025-01-07T16:49:13.7333333+00:00
Vision Intelligence
20
Reputation points
0 answers
How to fix 'Service and subscription limits' on PostgreSQL Fexible Server deployment using bicep file?
tags: ResourceDeploymentFailure, PostgreSQL Fexible Server deployment, bicep file, MS Learn tutorial, Git cloned .../mslearn-postgresql.git Exceptions support request with Issue type of 'Service and subscription limits'. I cannot file Exception Support…
asked 2025-01-07T13:57:32.81+00:00
József Orbán
25
Reputation points
commented 2025-01-07T15:49:19.3533333+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
905
Reputation points Microsoft Vendor
0 answers
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
commented 2025-01-07T10:16:33.8733333+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,166
Reputation points
1 answer
ERROR: permission denied for schema cron
Hi, I am running Azure PostgreSQL Flexible Server with PostgreSQL version 15.7. I am trying to enable pg_cron in my server on my custom database (not postgres), but I am getting the permission error: ERROR: permission denied for schema cron. I have…
asked 2024-12-30T09:58:35.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(284.8, 25%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Maira Tariq
0
Reputation points
edited an answer 2025-01-07T06:05:28.9066667+00:00
ShaktiSingh-MSFT
16,166
Reputation points
1 answer
Azure database for Postgres Flexible server - Why creating extension requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server Currently, I have faced the issue when creating an extension, it said that the user should be a member of azure_pg_admin. However, this was not the case a couple of months back as…
asked 2024-12-31T03:22:37.6833333+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, 16%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Cuong Tran
0
Reputation points
commented 2025-01-03T02:35:23.2+00:00
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
1 answer
Azure Cosmos for PostgresDB provisioning error when specifying authConfig
I'm seeing an issue when trying to provision a Cosmos for PostgresDB instance using terraform/arm templates. I can provision this configuration successfully, but if I uncomment the 'authConfig' block it fails with a "500 - Internal Server…
asked 2024-12-31T10:53:33.0433333+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(25.6, 45%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PGT
0
Reputation points
commented 2025-01-03T02:10:12.98+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,760
Reputation points Microsoft Vendor
1 answer
How to migrate Postgres Database from One Azure Entity to Another Azure Entity
Hi, We have a PostgreSQL flexible server hosted on Azure under the entity (abc.com). Due to some business changes, we need to migrate the PostgreSQL database from entity (abc.com) to entity (xyz.com). Could you please suggest the best ways to perform…
asked 2024-12-18T06:19:36.7233333+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(214.4, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kode Sasikiran
0
Reputation points
commented 2025-01-02T09:35:53.9733333+00:00
Kode Sasikiran
0
Reputation points
2 answers
Azure postgresql server getting stuck
My Azure PostgreSQL managed database server is stuck. I tried connecting to it, but it didn't work. When I attempted to restart the server, I received the error: "The server is currently in 'restarting' state. Please wait for the operation to…
asked 2024-12-23T14:24:57.3633333+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(6.4, 73%, 10%)' 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)
MR Subbato
0
Reputation points
commented 2024-12-31T09:43:41.9433333+00:00
NIKHILA NETHIKUNTA
4,010
Reputation points Microsoft Vendor