Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
345 questions
2 answers
How to Shrink Azure Postgres Flexible Storage With Minimal Downtime
Could you help me shrink the storage of an Azure PostgreSQL Flexible Server from 2000GB to a more appropriate because used space is only 300GB? The issue was occurred when the database on auto-grow and the storage consumption suddenly increased from…
Azure Database Migration service
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-12T13:13:58.97+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, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sachin Soam
0
Reputation points
commented 2024-07-15T15:58:09.6366667+00:00
Oury Ba-MSFT
20,911
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
Azure PostgreSQL flexible server stuck in restart state
I tried to restart my Azure Database for PostgresSQL flexible server now more than two days ago and it is still stuck in the restarting status. I initiated the restart because it wouldn't show me the list of databases so I could manually connect to them…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-15T10:30:47.5466667+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, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jespersen, Martin Closter
20
Reputation points
accepted 2024-07-15T10:58:21.8+00:00
Jespersen, Martin Closter
20
Reputation points
1 answer
error fetching from postgres, err: x509: certificate signed by unknown authority
i have i virtual network where in 1 subnet my aks cluster is present and another subnet my private postgress flexible server is present. i am connecting my application from aks cluster to private postgress server through private network using…
Azure Kubernetes Service
Azure Kubernetes Service
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,448 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-05T07:21:57.52+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(265.6, 51%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kishor
0
Reputation points
commented 2024-07-12T06:47:28.5833333+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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Duserla
7,935
Reputation points Microsoft External Staff
Moderator
1 answer
Postgre-SQL Flexible Server - pg_cron permissions and alternative
Hi everyone, a customer is using Azure PGSQL Flexible server to provide database managed services for its internal customers. The internal customers are used to work on-prem with job schedulers like pg__cron or pg__timetable. After migrating their…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-04T07:36:43.75+00:00
Paul Hernandez
686
Reputation points Microsoft Employee
answered 2024-07-11T09:05:34.2633333+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)
SSingh-MSFT
16,371
Reputation points
Moderator
1 answer
My Azure Server Admin has CreateRole rights disabled for Azure Database for Postgresql Flexible server
In the Azure Database for Postgresql, Recently the CreateRole rights have been revoked for the Server Admin user. Due to this, I am not able to create new users or roles in the system. Please help me to enable the create role access for the Azure Server…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-11T05:01:20.0633333+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, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nathar Hussain
0
Reputation points
answered 2024-07-11T08:54:58.3466667+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
2 answers
One of the answers was accepted by the question author.
Can you install extensions for Azure Data Studio when you are offline ?
We want to install Azure Data Studio (ADS) onto a server - and add the postgres extension. (The postgres database is local, not in Azure). The server has no internet access. We can download an installer for ADS and install it with no internet…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2021-09-03T11:00:49.22+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, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Greg Booth
1,371
Reputation points
commented 2024-07-10T10:04:49.9366667+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(291.2, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pfannkuchen, Michael
0
Reputation points
1 answer
Create Function with LANGUAGE c gets ERROR: permission denied for language c
We are migrating a database from PostgresSQL single server to flexible server using psql to dump and restore. All those functions with 'language c' would return ERROR: permission denied for language c A sample function like this: CREATE OR…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-09T01:40:44.7566667+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, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
ITAdmin - TOLFIN
0
Reputation points
commented 2024-07-10T09:23:26.08+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
1 answer
What happens to Azure Database for PostgreSQL - Single Server Reservations after the retirement announcement?
As I know, Azure Database for PostgreSQL - Single Server is on the retirement path and is scheduled for retirement by March 28, 2025. In case I bought 1-year reservation on May 1, 2024 and the reservation will expire on May 1, 2025 exceed retirement…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-05T03:18:23.0033333+00:00
Padtawee Srisan-ngam
65
Reputation points
commented 2024-07-10T05:04:49.2733333+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
0 answers
Error while creating new indexes on Azure database
Hello The migration from on premise to Azure has been done with success with all the metadata and data the 18/06/2024. It included indexes. At this time we had no errors. Now we want to try to create new BTREE indexe on our database but it fails with the…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-06-28T08:24:28.7133333+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, 41%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
JOLY, Josselin (ITOP CD) - AFKL
0
Reputation points
commented 2024-07-09T14:26:40.4366667+00:00
GeethaThatipatri-MSFT
29,542
Reputation points Microsoft Employee
Moderator
1 answer
az account get-access-token command issue
Hi All, We are using below command to get the JWT token for login to Postgres single server. az account get-access-token --resource-type oss-rdbms -o tsv --query accessToken However this command earlier returing the all groups of the lodded in user but…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-05T12:54:08.7733333+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, 28.000000000000004%, 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)
Mittapelli, S (Sathishkumar)
0
Reputation points
answered 2024-07-08T22:26:16.5333333+00:00
Oury Ba-MSFT
20,911
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
azure database for postgres フレキシブルサーバーTLS証明書の更新について
現在azure database for postgres フレキシブルサーバーを利用しているのですが、azureからルートストアに関する証明書の更新について通知がありました。そこでは、クライアント側にて既存で利用しているDigicert グローバル ルート CAと併せて、Microsoft RSA Root Certificate Authority…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
![](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(259.20000000000005, 7.000000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
1 answer
Azure Database for PostgreSQL flexible server upgrade from 14 to 15 with timescaledb extension
Using Azure Database for PostgreSQL flexible server, version 14 with the TimescaleDB extension version 2.10.0. We are planning to perform an in-place upgrade to PostgreSQL version 15. According to Azure documentation, TimescaleDB version 2.10.0 is…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-02T08:25:11.3133333+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(169.60000000000002, 0%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Boris Kočar
0
Reputation points
commented 2024-07-04T13:16:32.23+00:00
Boris Kočar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
what indicates the message “server restarted” in the return_message column in the cron.job_run_details table
what indicates the message “server restarted” in the return_message column in the cron.job_run_details table As per my understanding, the message “server restarted” in the return_message column of the cron.job_run_details table typically indicates that…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-02T14:27:55.3966667+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, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
accepted 2024-07-03T08:56:04.6666667+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
0 answers
postgresql
in azure we have postgresql and postgresql flexible the problem that some of the sdk calls that reappearance to the end_point is under the postgresql and not the postgresql flexible so i cant get the info from my postgresql also when you open regular…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-02T06:02:18.0266667+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(128, 56.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tommy Mordehay
0
Reputation points
commented 2024-07-03T06:25:01.1533333+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
1 answer
Admin user can't access user databases
Hey, I have migrated from single server to flexible server using database migration service I am having this following issue the admin user creates user using CREATE USER new_user WITH ENCRYPTED PASSWORD {}; next, GRANT ALL PRIVILEGES ON…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-07-02T09:15:47.07+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(86.4, 66%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Noronha, Vinson (Allianz Technology)
0
Reputation points
commented 2024-07-03T06:04:37.41+00:00
Deepanshu katara
16,565
Reputation points MVP
Moderator
2 answers
One of the answers was accepted by the question author.
Not able to Insert Image data for two images Postgresql
[HttpPost] [ValidateAntiForgeryToken] public async Task
Developer technologies | ASP.NET | ASP.NET Core
4,819 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
Azure | Azure Startups
816 questions
asked 2024-06-11T19:37:32.6+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(128, 8%, 22%)' 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)
Anonymous
edited the question 2024-07-03T04:22:20.2+00:00
Ryan Hill
30,281
Reputation points Microsoft Employee
Moderator
1 answer
Issues with Purview Scanning Azure Postgres instance
When scanning a Azure PostgreSQL instance - getting the following. We connect but are unable to scan. We are using a Sysadmin Postgres account for scanning. Here is the…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
asked 2024-06-26T19:24:18.1533333+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, 69%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Stephen Barry
0
Reputation points
commented 2024-07-02T19:18:21.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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
31,261
Reputation points Microsoft Employee
Moderator
2 answers
One of the answers was accepted by the question author.
Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity
Hi, I need to deploy a webApp running .NET Code and Azure Database for PostgreSQL flexible server. Our policy is to grant webApps/functionApps access to SQL Server/MySql Server/PostgreSQL Server via Managed Identity. While, I can see connection strings…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,947 questions
Developer technologies | .NET | Other
4,104 questions
Microsoft Security | Microsoft Identity Manager
882 questions
3 answers
One of the answers was accepted by the question author.
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
Azure Database Migration service
Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
345 questions
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
64 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
990 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
asked 2023-11-02T16:25:02.83+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(9.6, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Albeiro Jimenez Lopez
20
Reputation points
commented 2024-07-01T17:08:09.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(288, 48%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uliana Philippova
0
Reputation points
1 answer
Azure Data Studio with PostgreSQL connection type cannot connect to server
Hello, I'm currently trying to connect to a server via a PostgreSQL connection on Azure Data Studio. I installed the app from the official webpage and then added the PostgreSQL extension via the app extensions interface. I have copied a configuration…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
141 questions
asked 2024-06-28T14:33:01.2333333+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(118.4, 82%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Ludovic Arnould
0
Reputation points
commented 2024-07-01T15:20:26.7466667+00:00
GeethaThatipatri-MSFT
29,542
Reputation points Microsoft Employee
Moderator