Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
927 questions
1 answer
Postgresql database missing from subscription
I have a database that has disappeared from a resource group in my azure subscription. The database still exists as i can connect to it externally, just I can't see it via portal or through powershell. Any suggestions as to how to get it relinked to my…
asked 2021-02-17T12:02:48.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(80, 65%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Allan, David F
1
Reputation point
commented 2021-02-23T00:22:17.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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
How to get infos about pending postgres db restart programmatically
Hi, in Azure PostgreSQL, when changing some server params, the Server requires a restart and denotes this on the Server Parameters page. Is there any way to find about a pending restart programmatically? az postgres server show or config show…
asked 2021-02-12T10:07:57.897+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, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Björn Pohl
1
Reputation point
commented 2021-02-17T05:51:47.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(297.6, 97%, 38%)' 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)
Anurag Sharma
17,586
Reputation points
3 answers
Data Factory long-running parallel executions
Hello folks, I have a "long-running" pipeline, by my estimates, it should only take about 24 hours to complete. I started the pipeline after dinner on Friday and let it go until Monday morning, and by all means it should have completed,…
asked 2021-02-01T14:05:34.757+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(121.6, 60%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Robert Riley
21
Reputation points
answered 2021-02-16T18:12:09.02+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(172.8, 70%, 26%)' 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)
MartinJaffer-MSFT
26,051
Reputation points
1 answer
Unable to delete Virtual Network binded to a deleted flexible Postgresql Server.
Hi, I has to create a postgresql server for a project deployment for AKS. It's work and I complete my test. I caught an error when I try to deleted It. The error : Échec de l'enregistrement du sous-réseau « picomto-test-postgresql-subnet ».…
asked 2021-02-08T16:08:59.073+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(134.4, 46%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
matthias.desrumaux
1
Reputation point
commented 2021-02-16T14:43:27.873+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, 36%, 14%)' 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)
SaiKishor-MSFT
17,216
Reputation points
1 answer
Azure PostgreSQL Database failed connections
We have PostgreSQL database hosted on Azure as "Azure database for PostgreSQL". Whenever I try to monitor database using Metrics -- > Failed Connection , it shows 4 failed connections every minute and sometime it rises high up to 25-30…
asked 2021-02-15T09:00:36.373+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(99.2, 93%, 19%)' 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)
sappu solanki
66
Reputation points
answered 2021-02-16T04:17:52.253+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, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
PostgreSQL Active Directory Admin - DB in inconsistent state
I have put my Azure Postgres db into an inconsistent state w.r.t. the Azure Active Directory Admin from which I can't recover. The issue is that the Portal (and az cli) report that an AD Admin is configured for the database, but when I try to connect…
asked 2021-01-29T20:34:29.037+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, 17%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFO%3C/text%3E%3C/svg%3E)
Felix Obenauer
11
Reputation points
answered 2021-02-11T03:42:31.187+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, 79%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHO%3C/text%3E%3C/svg%3E)
Hugh O'Brien
1
Reputation point
1 answer
Requesting additional privileges for Azure Postgres User
Hi.. I need some help regarding privileges. I have an Azure Database for Postgresql server with you. I have access to a Postgres user and a PGDBO user account both of which have very restricted permissions. I'm trying to perform a data migration but in…
asked 2021-02-06T13:09:16.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(3.2, 78%, 10%)' 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)
Ash
1
Reputation point
commented 2021-02-10T16:48:56.11+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Unable to run migrations for django web-application with Postgresql database.
Hi, I have followed this https://video2.skills-academy.com/en-us/azure/developer/python/tutorial-python-postgresql-app-portal to deploy my web application onto Azure. I am struggling at the section "Run Django database migrations". I've…
asked 2021-02-02T14:55:37.963+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, 77%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dodson, Arthur
1
Reputation point
commented 2021-02-08T15:06:44.57+00:00
Dodson, Arthur
1
Reputation point
1 answer
Pgbounce issue with Azure Postgres Flexible server
Hi, I'm having issues using pgbouce with an Azure Postgres Flexible Server. When I configure and try to connect my app throught pgbounce I always get "no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "xxxxxxxxx", database…
asked 2021-01-22T12:57:26.883+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, 21%, 18%)' 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)
Alberto Salazar
1
Reputation point
commented 2021-02-04T17:20:54.363+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
The Read method cannot be called
Hello, I am having an issue with the npgsql connector to postgres. Error message below: 'Type=Npgsql.NpgsqlException,Message=Exception while reading from stream,Source=Npgsql,''Type=System.NotSupportedException,Message=The Read method cannot be…
asked 2021-01-20T14:45:15.307+00:00
Robert Riley
21
Reputation points
commented 2021-02-02T17:57:29.783+00:00
Robert Riley
21
Reputation points
2 answers
Change database username format
I have an architecture deployed and a DNS upper this. With this I can change the db server without impacting the final services. In this case If I need to do this change I have to change also the username into all services just because the username is…
asked 2021-01-19T13:42:49.797+00:00
Alberto Salazar
1
Reputation point
answered 2021-02-01T06:00:52.617+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
One of the answers was accepted by the question author.
Create a PostgreSQL DB Server with Basic pricing tier by Geo-Restoring a PostgreSQL DB Server with General Purpose pricing tier
I get 1 Azure PostgreSQL DB servers: "DBServerA" under subscription "MySubscription" and resource group "MyResourceGroup". "DBServerA" has sku GP_Gen5_2 and its geoRedundant is enabled. I would like to create a…
2 answers
Killing Idle connections in azure database for postgresql
Hi Experts, Looking for some inputs on below requirement. we have few servers On azure database for postgresql (single server) , the requirement is to configure and act upon an metric (Active connections >600) and run a script to kill idle…
asked 2021-01-26T18:42:31.48+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(208, 87%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
sql user
86
Reputation points
answered 2021-01-27T13:47:57.617+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
Powershell: how to get Active Directory Administrator of Azure Database for PostgreSQL?
Hi, is there any equivalent of "Get-AzSqlServerActiveDirectoryAdministrator" cmdlet which can be used to retrieve the Active Directory Administrator of the selected Azure Database for PostgreSQL? Unfortunately, Az.postgresql module doesn't…
asked 2020-12-11T17:11:26.763+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(64, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
FlorBob
1
Reputation point
answered 2020-12-14T03:26:29.733+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Import posgreSQL database (Postgis extension) to database in Microsoft Azure to work with Qgis 3.4
Hi! I have the following problem: I am a university student of Geography and I use the Qgis 3.4 application connected to a local PostgreSQL server with Postgis extension to edit vector files. As we are doing an internship, I would like academics to be…
asked 2020-12-13T21:10:49.997+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(121.6, 15%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Juliano Fonseca
6
Reputation points
answered 2020-12-13T23:27:00.767+00:00
Juliano Fonseca
6
Reputation points
4 answers
One of the answers was accepted by the question author.
Updating Firewall rules has no effect for Azure Database for PostgreSQL
Dear Community, However i've set up the firewall to allow all traffic, i'm unable to access the database over pgadmin. I've tried multiple user accounts. Is this a current known issue? Please see the firewall rules and the error i receive on…
asked 2020-06-04T09:17:28.377+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, 67%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Leon Graveland
31
Reputation points
answered 2020-12-11T14:09:02.837+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(140.8, 34%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Felipe
6
Reputation points
1 answer
Failure of Restoring (Point-in-time) an Azure PostgreSQL DB Server
I get 2 Azure PostgreSQL DB servers: "DBServerA" and "DBServerB" under subscription "MySubscription" and resource group "MyResourceGroup". I have following script: az account set --subscription MySubscription …
asked 2020-12-10T19:15:31.827+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(256, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Tim Jin
36
Reputation points
answered 2020-12-11T09:20:30.137+00:00
Anurag Sharma
17,586
Reputation points
1 answer
How to do I develop Power BI reports off of Azure Postgre SQL ?
Hello, On Power BI report builder - we dont see an option to connect to Postgre SQL This thread was also not useful as we cannot see ODBC option :…
asked 2020-12-09T04:34:42.35+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(214.4, 55.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Raj Patrao
21
Reputation points
answered 2020-12-09T07:08:56.08+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure PostgresSQL: Want to create NOSUPERUSER role, getting "ERROR: must be superuser to create superusers"
Hi everybody, I´m getting crazy ;) especially because I already did this several times. Maybe I´m blind at the moment. I already tried several new deployments and version. I want to create a flexible server, but I tried with the Single Server as well: …
asked 2020-11-21T09:40:00.097+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, 12%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marius Hornung
21
Reputation points
commented 2020-12-09T00:55:25.86+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, 66%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Case
1
Reputation point
1 answer
Renewal of SSL certifcate on Postgres SQL server
Hi guys, I requested for SSL certificate from the PKI team, now I have to install it on postgres SQL server. Is there any documentation/steps for this how we can install it on server. Actually we install it directly on keytool but someone has…
asked 2020-12-02T06:38:53.437+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(304, 21%, 39%)' 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)
Ashima Gupta
66
Reputation points
commented 2020-12-02T12:48:08.667+00:00
Ashima Gupta
66
Reputation points