Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
930 questions
0 answers
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…
asked 2024-07-05T03:18:23.0033333+00:00
Padtawee Srisan-ngam
60
Reputation points
commented 2024-07-05T08:34:36.74+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
14,276
Reputation points Microsoft Employee
0 answers
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…
asked 2024-07-04T07:36:43.75+00:00
Paul Hernandez
631
Reputation points Microsoft Employee
commented 2024-07-05T08:32:56.4733333+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
0 answers
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…
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
edited the question 2024-07-05T07:41:51.3966667+00:00
KapilAnanth-MSFT
39,446
Reputation points Microsoft Employee
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…
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
answered 2024-07-04T13:16:32.23+00:00
Boris Kočar
0
Reputation points
0 answers
PostgreSQL - Flexible server maintenance taking forever
Hi. I was trying to troubleshoot an issue in our Test subscription last night when I realized that our "PostgreSQL - Flexible server" instance was taken offline for maintenance, with the message: The scheduled maintenance for your Azure…
asked 2022-07-06T11:05:58.387+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, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
wup
6
Reputation points
commented 2024-07-03T08:57:40.5533333+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, 45%, 26%)' 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)
Steve Pillar
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…
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…
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
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
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…
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
Deepanshukatara-6769
7,040
Reputation points
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
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,344 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
930 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.
236 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
26,866
Reputation points Microsoft Employee
2 answers
pg_stat_statements Extension issue in Azure Database for PostgreSQL flexible server
pg_stat_statements extension is enabled in Azure Database for PostgreSQL flexible server, but when I run the command select * from pg_stat_statements it is giving ERROR: relation "pg_stat_statements" does not exist
asked 2024-07-02T16:04:24.9766667+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
answered 2024-07-03T00:07:55.8033333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
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…
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)
BhargavaGunnam-MSFT
28,606
Reputation points Microsoft Employee
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…
Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
648 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,572 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
930 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,268 questions
0 answers
azure database for postgres フレキシブルサーバーTLS証明書の更新について
現在azure database for postgres フレキシブルサーバーを利用しているのですが、azureからルートストアに関する証明書の更新について通知がありました。そこでは、クライアント側にて既存で利用しているDigicert グローバル ルート CAと併せて、Microsoft RSA Root Certificate Authority…
![](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)
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
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
Ability to grant admin user ADMIN option in Azure PostgreSQL Flexible Server version 16
I have created a new flexible server at version 16 with 2 admins: Postgres admin called "adminuser" Microsoft Entra admin called "entraadmin" (visible at Security - Authentication on portal) My use case is to transfer ownership…
asked 2024-06-26T23:13:59.75+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(12.8, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYT%3C/text%3E%3C/svg%3E)
Yichen Tian
0
Reputation points
commented 2024-07-01T15:57:34.9133333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
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…
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,007
Reputation points Microsoft Employee
0 answers
I selected Storage Auto-growth option for my postgresql flexible server and then I restarted the server and since then the server is in 'restarting' state for 24 hours.
My Azure Postgresql Flexible Server has reached its storage limit, so I selected the Storage Auto-growth option. After 15 minutes nothing changed and I restarted the server. Since then, the server has been in 'restarting' state for 24 hours. Type of…
asked 2024-06-21T10:11:48.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(60.8, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cosmin Robert Lungu
0
Reputation points
commented 2024-07-01T06:06:53.23+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
0 answers
getaddrinfo EAI_AGAIN error when connecting to Postgres DB
Hi, One of our team is getting the below error when their API hosted in AKS connecting to Postgres DB (Configured using Private endpoint). This error is generated at random requests, say in a day 50 requests fails due to this. I verified the internal…
asked 2024-06-19T07:02:24.04+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(38.4, 12%, 13%)' 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)
Ravichandran, Gopi Krishna
161
Reputation points
edited a comment 2024-07-01T04:34:41.5433333+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, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Anveshreddy Nimmala
3,460
Reputation points Microsoft Vendor
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…
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-06-28T17:29:00.93+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to delete an Azure Database for PostgreSQL flexible server
When attempting to delete an Azure Database for PostgreSQL Server, the error message "An error occurred deleting PostgreSQL server. Unknown error." is displayed. The resource is empty and there are no user databases. How can I resolve this…
asked 2024-06-15T08:42:59.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(243.2, 19%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Christian Hageraats
20
Reputation points
accepted 2024-06-28T10:41:16.1366667+00:00
Christian Hageraats
20
Reputation points