Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
345 questions
0 answers
Azure DMS doing a Full Load each time for a FAILED activity on PostgreSQL
Looking to migrate a 1 TB PostgreSQL database from on-prem ubuntu VM to Azure PostgreSQL Flexible Server using Azure DMS. Appears Azure DMS is doing a full load each time the migration activity fails (like when the source database is restarted, network…
Azure Database Migration service
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-12T17:28:57.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(249.60000000000002, 7.000000000000001%, 34%)' 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)
K Sateesh Kumar Reddy
0
Reputation points
commented 2024-01-13T18:12:42.0733333+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
Azure Database for PostgreSQL single server - Unable to connect, Connection Security page not loading
I am unable to connect to my Azure Database for PostgreSQL single server, and I am also unable to restart it. When accessing the Connection Security settings or the Server parameters page on the portal.azure.com website, the pages do not load. The server…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-09T10:07:06.19+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(316.8, 12%, 40%)' 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)
Marichal, Stephane
0
Reputation points
edited a comment 2024-01-12T05:25:27.8866667+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
azure database for postgres and laravel application connection
i have created azure database for postgres and uploaded my database there. and give the connection details in local database IDE and am getting the connection and works smoothly. but when i connect to azure database using local laravel application am…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-09T06:39:56.7066667+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, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMI%3C/text%3E%3C/svg%3E)
Milestone IT
20
Reputation points
commented 2024-01-12T05:21:19.57+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
0 answers
Error conection postgres
I have a VM on Azure from which I'm trying to connect to a PostgreSQL database on Azure. The connection is not working, but if I use VS Code on Windows, the connection works. I have checked ufw, the firewall, and PostgreSQL. I have also installed…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-06T08:57:16.6266667+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, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrei Haba
0
Reputation points
commented 2024-01-11T12:10:58.7933333+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, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alicja Kucharczyk
195
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Postgresql Flexible Server with Vnet integration
Hi We have created a Azure Postgresql Flexible server with VNET integration. When we are trying to connect to it from the pgadmin installed on local machine, it is giving connection issue. We have checked and found network issues. In one of the MS…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2022-03-23T16:28:55.947+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(67.2, 35%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Abhay Gupta
71
Reputation points
commented 2024-01-10T22:17:20.9266667+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
3 answers
How to upgrade and downgrade Azure PostgreSQL flexible server using script and crontab?
I attempted to use a Python, Shell, or Bash script with crontab to upgrade and downgrade an Azure PostgreSQL flexible server but received an error message: "az postgres: 'flexible-server' is not in the 'az postgres' command group." It appears…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-28T06:05:04.4033333+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(176, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mehedi
0
Reputation points
answered 2024-01-09T12:20:49.7966667+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
1 answer
I was trying to deploy PostgreSQL with Private Endpoint via terraform but currently encountering this issue.
Error: creating Private Endpoint "private-endpoint" (Resource Group "RGName"): network.PrivateEndpointsClient#CreateOrUpdate: Failure sending request: StatusCode=400 -- Original Error:…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-11-28T05:30:51.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(230.39999999999998, 99%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Lana Joy Yandoc
5
Reputation points
commented 2024-01-08T14:46:03.8333333+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, 94%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM2%3C/text%3E%3C/svg%3E)
Martin-2211
0
Reputation points
2 answers
Query to give all permissions to a user on a PostgreSQL database
what is the query to grant all permissions to a user on complete database level in PostgreSQL. And what sort of permissions we will get if we run that statement.
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-06T11:16:58.9566667+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
answered 2024-01-08T05:29:47.4066667+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
2 answers
One of the answers was accepted by the question author.
cost impact for the extensions in Azure Database for PostgreSQL flexible server
I would like to know if there is any cost impact if I enable all the extensions in Azure.Extensions server parameters for Azure Database for PostgreSQL flexible server
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-28T03:40:20.9+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
edited an answer 2024-01-07T15:09:46.38+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
1 answer
One of the answers was accepted by the question author.
pgstattuple query performance
I am trying to build the query that checks dead tuples, live tuples percent, free space etc., in all my users tables using pgstattuple extension. Can you please help me with the query? Just FYI., there are couple of large tables with more than 100GB of…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-02T09:36:22.63+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
accepted 2024-01-07T06:20:15.8666667+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
1 answer
pg_restore problem
I want to restore a postgres database and i have a problem. i do this line of code pg_restore -Fd -j 2 -d template1 /var/lib/postgresql/backup.dump -h postgres-17.postgres.database.azure.com -p 5432 -U habacookplok 2> ~/errors.log => i specify…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-02T11:42:21.7333333+00:00
Andrei Haba
0
Reputation points
commented 2024-01-05T16:00:48.2966667+00:00
GeethaThatipatri-MSFT
29,552
Reputation points Microsoft Employee
Moderator
2 answers
One of the answers was accepted by the question author.
How to enable Azure Active Directory Authentication for Azure Database for PostgreSQL flexible server
How to enable Azure Active Directory Authentication for Azure Database for PostgreSQL flexible server?
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-02T16:06:48.44+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
commented 2024-01-04T15:30:11.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(80, 31%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Joshua Head
0
Reputation points
2 answers
Is there any query to fetch disk space occupied by a tablespace in Azure Database for PostgreSQL flexible server
Is there any query to fetch disk space occupied by a tablespace in Azure Database for PostgreSQL flexible server
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-25T15:45:12.71+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
commented 2024-01-04T05:50:59.8466667+00:00
SSingh-MSFT
16,371
Reputation points
Moderator
4 answers
One of the answers was accepted by the question author.
What are the new server parameters added in Azure Database for PostgreSQL flexible server for Postgresql version 15. Are there any deprecated server parameters
What are the new server parameters added in Azure Database for PostgreSQL flexible server, for PostgreSQL Version 15?
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-30T11:12:14.2333333+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
accepted 2024-01-04T02:36:56.93+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
1 answer
One of the answers was accepted by the question author.
How to achieve near zero-downtime version upgrade with PostgreSQL flexible server
The docs speak about "in-place major version upgrade process" https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-major-version-upgrade which "results in a brief period of downtime. Typically, the downtime is under…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-30T15:52:33.1766667+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, 44%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ruppel, Julian
70
Reputation points
accepted 2024-01-03T19:00:01.0733333+00:00
Ruppel, Julian
70
Reputation points
1 answer
One of the answers was accepted by the question author.
How to clone a database from one azure postgres flexible server to another.
How to clone a database from one azure postgres flexible server to another.
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-11-07T15:58:36.53+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, 67%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vasek Polak
80
Reputation points
commented 2024-01-03T06:14:59.7766667+00:00
Alicja Kucharczyk
195
Reputation points Microsoft Employee
0 answers
Permission denied for schema cron
I configured the pg_cron extension on our postgresql 15 flexible server, however, I've been stuck for a while now trying to figure out how I am suppose to do anything with the cron schema. We upgraded from 14 to 15 couple of days back. I've added pg_cron…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2024-01-03T03:36:07.66+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
commented 2024-01-03T06:06:32.0366667+00:00
Alicja Kucharczyk
195
Reputation points Microsoft Employee
1 answer
how can I see the Pg_cron logs in the PostgreSQL log
We enabled the logs in the Azure portal, how can I see the Pg_cron logs, the outcome of jobs, in the PostgreSQL log. Just FYI., below server parameters are set to ON: cron.log_run=ON cron.log_statement=ON
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-28T12:07:24.7+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
commented 2023-12-29T22:27:14.14+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
0 answers
Optimizing Performance for Postgre SQL database
Hello All, Unlike SQL Server query execution plan etc, can someone guide me as to how to or steps to optimize the performance of a postgre SQL database. Currently I am using the below sugesstions : …
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 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(140.8, 39%, 23%)' 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)
1 answer
One of the answers was accepted by the question author.
Query to find out when the last time a database backup was taken in PostgreSQL
Looking for a query to find out when the last time a database backup was taken in Azure Database for PostgreSQL flexible server.
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2023-12-25T15:12:56.11+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
accepted 2023-12-25T15:40:16.4933333+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points