azure database for postgres フレキシブルサーバーTLS証明書の更新について
現在azure database for postgres フレキシブルサーバーを利用しているのですが、azureからルートストアに関する証明書の更新について通知がありました。そこでは、クライアント側にて既存で利用しているDigicert グローバル ルート CAと併せて、Microsoft RSA Root Certificate Authority…
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…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB in Azure flex postgres
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/vub1NJcKNEmWqsNK_A71uw.png?8DA872)
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…
![](https://techprofile.blob.core.windows.net/images/0Ll-SHZePUetqUTMg1J81A.png?8D7EDA)
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…
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…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/K-17JMffHkWm3NCsMSk3cA.png?8DBA52)
Not able to Insert Image data for two images Postgresql
[HttpPost] [ValidateAntiForgeryToken] public async Task
![](https://techprofile.blob.core.windows.net/images/3b270b575c094eeca63e9bc66c861c5a.png)
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
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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…
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…
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
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…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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…
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…