Azure SQL Database
An Azure relational database service.
5,959 questions
1 answer
On-premise to Azure SQL connectivity
I'm seeking a low-cost solution for on-premise to Azure SQL connectivity. We already have an Azure environment with 4 Subscriptions in a Hub & Spoke model. Traffic from within the on-premise VPN connects to the Hub VNet via a VPN Gateway, then it…
asked 2023-06-14T16:01:58.65+00:00
TheoF
1
Reputation point
commented 2025-02-01T14:52: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(60.8, 18%, 15%)' 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)
Sanjana Pushkar
0
Reputation points Microsoft Employee
0 answers
Issues Connecting to PostgreSQL Flexible Server in Azure VPC with Terraform
Deploying a PostgreSQL Flexible Server inside a VPC using Terraform has been successful, but there is an issue with connecting via Point-to-Site VPN. After following the instructions listed here, connection attempts still fail. Attempts to resolve the…
asked 2025-01-28T01:15:27.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(48, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
William Kelly
0
Reputation points
commented 2025-01-31T18:04:40+00:00
William Kelly
0
Reputation points
1 answer
Azure - are there minimum increments for B Series CPU credits? A threshold?
We have a B20ms "Flexible Server for Postgres" that has been running under a light load for several weeks. It has significant CPU credit of around 5,450. Periodically, the CPU has risen above 10% and the CPU credit has drained slightly at…
asked 2025-01-29T18:20:53.55+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
edited a comment 2025-01-31T17:10:38.3333333+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,430
Reputation points Microsoft Vendor
0 answers
How to add pgaadauth in azure pg flexible servers it is always giving error,Also how to add pg_cron to a db
CREATE EXTENSION IF NOT EXISTS pgaadauth; ERROR: extension "pgaadauth" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL HINT: to learn how to allow an extension or see the list of allowed extensions,…
asked 2025-01-31T09:41:54.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(48, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aditya Singh
0
Reputation points
commented 2025-01-31T12:49:53.6633333+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
1,065
Reputation points Microsoft Vendor
0 answers
Does COPY lock my TimescaleDB database with 70k chunks?
I am using TimescaleDB in an Azure VM for an IoT database. I need to export data in CSV format using the COPY method, but I have around 70,000 chunks in my hypertable. My concern is whether executing COPY to export data locks the database, as it is…
asked 2025-01-30T14:12:30.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(300.8, 5%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
KriShna PrakaSh
0
Reputation points
edited a comment 2025-01-31T11:09:51.2166667+00:00
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
2 answers
How to Export Data from TimescaleDB in Azure VM to CSV Format
I am working with a TimescaleDB instance installed inside an Azure Virtual Machine (VM), which is actively being used in production. I need to export data for the 2,000 most active users from the past year, including user profile information and device…
asked 2025-01-28T08:14:14.7733333+00:00
KriShna PrakaSh
0
Reputation points
commented 2025-01-31T08:30:04.8733333+00:00
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
1 answer
I did not have the logs activated but I need to know who have accessed my database is a postgres sql
I did not have the logs activated but I need to know who have accessed my database to know that IP was used to access the system is there a way to get that historical the database is SQL progress?
asked 2025-01-29T16:17:58.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(163.2, 62%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Victor Alan Miranda Cortez
0
Reputation points
commented 2025-01-31T01:26:21.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(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
2,155
Reputation points Microsoft Vendor
1 answer
Azure PostgreSQL Flexible Server – Slow Start/Stop & HTTP 500 Errors
I am experiencing issues with my Azure Database for PostgreSQL Flexible Server. The instance is taking a very long time to start and stop, and I frequently encounter HTTP 500 Internal Server Errors when attempting these actions through the Azure…
asked 2025-01-28T14:01:36.0166667+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, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOK%3C/text%3E%3C/svg%3E)
Osama Khan
20
Reputation points
commented 2025-01-30T16:34:25.5366667+00:00
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
1 answer
Azure flexible Postgres storage capacity usage unknown
Hello, We are facing a problem which is baffling us, we have some databases on "Azure Database for PostgreSQL - Flexible Server" we summed the size of disk usage by these databases and included the managed dbs and came to a total of 121GB of…
3 answers
One of the answers was accepted by the question author.
Can I change to owner of a database in Azure Database for PostgreSQL flexible server?
I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…
asked 2024-06-12T19:41:39.73+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, 23%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kristine Kisman
25
Reputation points
answered 2025-01-29T19:51:10.8666667+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, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chris Procter
11
Reputation points
0 answers
Error While Migrating from Azure PostgreSQL Single Server to Flexible Server
Hi Community, I’m encountering an issue while migrating from Azure PostgreSQL Single Server to Flexible Server using the Azure Database Migration Service. Error Details During the migration of a database (e.g., database_name), the process failed with…
asked 2024-11-29T14:29:23.0933333+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, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SoniaD_74
0
Reputation points
commented 2025-01-29T18:07:13.7+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Oluwatimilehin Alabi
0
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-28T17:02:13.93+00:00
Mahesh Kurva
2,430
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to migrate database users from Azure PostgreSQL single server to flexible server?
Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…
asked 2024-05-06T18:47:09.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(217.60000000000002, 15%, 31%)' 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)
Pratik
25
Reputation points
answered 2025-01-28T16:50:06.6033333+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(268.8, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Luca Baumann
0
Reputation points
0 answers
How to Sync Azure Postgres from one instance to other instance
Hello Everyone, My requirement, we have Managed Azure PostgreSQL instance running in Prod and we want to replicate the Dev PostgreSQL every day might, through Azure Function, how than be accomplished. I want to use Python for achieving this, any help is…
asked 2025-01-28T03:41:08.23+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(211.20000000000002, 76%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Niranjan Jannapureddy
0
Reputation points
commented 2025-01-28T15:39:55.54+00:00
Niranjan Jannapureddy
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Cannot Connect to PosgresDB Flexible Server From in Private AKS
Hi all, I am experiencing an issue with connecting to a PostgreSQL database from a private AKS cluster. The AKS and the database are located in two different virtual networks and subscriptions. To debug the connection, I created a pod using the following…
asked 2025-01-13T09:14:08.78+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(89.60000000000001, 32%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Huynh, Huu Thang
20
Reputation points
edited the question 2025-01-28T12:12:10.1433333+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
4,120
Reputation points Microsoft Vendor
2 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-28T09:12:41.2333333+00:00
Vijayalaxmi Kattimani
1,065
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-28T09:00:45.1266667+00:00
Vijayalaxmi Kattimani
1,065
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-28T03:55:57.2166667+00:00
Sai Raghunadh M
2,155
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-28T03:51:25.78+00:00
Sai Raghunadh M
2,155
Reputation points Microsoft Vendor
0 answers
How to defer a scheduled migration of my Single Server to Flexible Server?
Q: How do I defer Microsoft's scheduled migration of my Single Server to Flexible Server. A: From Microsoft: Issue: Below is an image of what I see in Azure migration section. How do I defer the date? Do I click the "Start Migration"…
asked 2024-09-13T14:02:55.1466667+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, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Daryl Williams
20
Reputation points
commented 2025-01-27T19:47:23.91+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, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bryant Poston MC
0
Reputation points