Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
955 questions
2 answers
Error with CTE when it doesnt recognize the table
I'm trying to run this query, but unfortunately I keep getting the error of "first_table" doesn't exist. Is there a way to fix this. I've tried every scenario i could think of and still nothing. any help willl be very helpful with first_table…
asked 2020-10-01T20:13:45.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(272, 15%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
learning_step_by_step
61
Reputation points
commented 2020-10-06T00:04:38.88+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
In Azure Postgres , does the latest offering of "Flexible server (Preview)" support certificate authentication
In Azure Postgres , does the latest offering of "Flexible server (Preview)" support certificate authentication Can i get the pricing link for this flexible server. Please advise.
asked 2020-10-01T10:49:06.937+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(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
MS Techie
2,691
Reputation points
answered 2020-10-05T11:38:40.2+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,591
Reputation points
1 answer
One of the answers was accepted by the question author.
Failed to connect to Azure PostgreSQL with SSL enabled from AzureDataStudio
When i try to connect to Azure PostgreSQL with SSL enabled using AzureDataStudio , with SSL Mode=Verfiy-full, i get below error root certificate file "C:\Users\mstechie\AppData\Roaming/postgresql/root.crt" does not exist Either provide…
1 answer
Certificate rotation using azure's pgbouncer docker image
We use the pgbouncer docker image and want to know whether this image has been updated to contain the new certificate Cert rotation: https://learn.microsoft.com/en-gb/azure/postgresql/concepts-certificate-rotation#what-update-is-going-to-happen …
asked 2020-09-21T06:29:19.713+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, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brendan
1
Reputation point
commented 2020-10-02T02:01:45.787+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
DevOps for Azure Database for PostgreSQL
Is there any Azure DevOps option to configure CI CD for Azure Postgres Database PaaS option ? Please help
asked 2020-09-25T17:12:24.963+00:00
MS Techie
2,691
Reputation points
commented 2020-09-30T04:18:41.36+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Does the PaaS offering from Azure , that is Azure PostgreSQL support custom certificate?
https://learn.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security From the above Microsoft URL , i can see that Azure PostgreSQL supports having an SSL certificate , in connection string. Eg: psql "sslmode=verify-full…
asked 2020-09-18T06:51:03.213+00:00
MS Techie
2,691
Reputation points
commented 2020-09-29T17:27:56.457+00:00
Anurag Sharma
17,591
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure PostgresSQL hyperscale citus - Modify the password policy
We are moving Azure postgres single server instance to hyperscale mode. On hyperscale postgres , as per documentation roles need to be created from portal .I need clarification on following 1)Is it possible to create user / role from psql 2)Is there…
asked 2020-09-17T11:17:56.417+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(51.2, 96%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Honey Nadackal
126
Reputation points
accepted 2020-09-29T04:55:59.7+00:00
Honey Nadackal
126
Reputation points
1 answer
Azure PG edit pg_ident.conf
I was wondering if it was possible to edit the pg_ident.conf file. I am hoping that a mapping will resolve the issue our application is having with the @hostname. I want to avoid changing the code. I can currently connect to Google PostgreSQL…
asked 2020-09-23T16:30:29.487+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(54.400000000000006, 75%, 15%)' 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)
Michelle Schwan
1
Reputation point
commented 2020-09-28T18:10:38.287+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Connecting Azure Kubernetes Service and Azure Database for PostgreSQL using Azure Key Vault .
Connecting Azure Kubernetes Service and Azure Database for PostgreSQL using Azure Key Vault . AKS : Cluster is ready Azure Database for PostgreSQL : DB is ready I would like to know the steps to connect to PostgreSQL DB on existing the AKS…
asked 2020-09-22T06:53:26.12+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(294.40000000000003, 19%, 38%)' 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)
Rajasekhar
16
Reputation points
commented 2020-09-28T11:34:46.237+00:00
prmanhas-MSFT
17,901
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
PostgreSQL images on Azure VM (Please see screenshot below) -- Are they managed like azure does OS updates etc for them ?
When we try to create a VM in azure , we get several options for PostgreSQL. I wanted to know if the azure VM on Postgre in below screenshot are managed .i.e . OS updates are taken care by Azure etc.
1 answer
One of the answers was accepted by the question author.
Migration Postgresql to Azure database for Postgresql
May I know if there are option to do migration using dump and restore using incremental method to lower the down time ? pg_dump , pg_restore
asked 2020-09-23T07:25:12.733+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(137.6, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2020-09-23T18:33:40.247+00:00
Anurag Sharma
17,591
Reputation points
2 answers
Backup postgres database to Azure blob storage
Is it possible to backup Azure managed postgres instance database to Azure blob storage with life cycle management policy on top of it.
![](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(0, 50%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
1 answer
Do azure postgresql support roaringbitmap?
we need the roaringbitmap extention, but do not in the support extentions list
asked 2020-09-22T02:42:16.517+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, 44%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERQ%3C/text%3E%3C/svg%3E)
rube qiu
76
Reputation points
answered 2020-09-22T04:32:37.857+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
External access to Azure PostgreSQL database
I am trying Azure PostgreSQL for the first time. After using their (start with a pre-set configuration) to provision the system, I don't seem to be able to connect externally. name@Azure:~$ psql --host=mendixdb.canadacentral.cloudapp.azure.com…
asked 2020-08-26T22:35:36.33+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(19.2, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
geoff belair
11
Reputation points
commented 2020-09-21T13:49:38.287+00:00
Anurag Sharma
17,591
Reputation points
1 answer
PostgreSQL Norway East
Hey! We are starting up a new project in Norway and wanted to test out having the database in Norway East/West instead of Europe West as previously used. All information I can find says that PostgreSQL should be available: …
asked 2020-09-11T11:07:30.28+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(278.4, 6%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Daniel Eriksen
1
Reputation point
answered 2020-09-14T06:59:34.793+00:00
Anurag Sharma
17,591
Reputation points
1 answer
Migrate Azure Database for PostgreSQL to On-Premise PostgreSQL
I want to migrate my Azure Database for PostgreSQL to my On-Premise PostgreSQL. How do I do it ? Does Azure supports any such migration tool for moving or copying databases from Azure to On-Premise and vice-versa. please advice.
asked 2020-09-10T17:30:48.273+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(137.6, 56.00000000000001%, 23%)' 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)
vijay ande
1
Reputation point
commented 2020-09-11T11:40:05.463+00:00
Anurag Sharma
17,591
Reputation points
1 answer
Power sheel Script need to exicute Sql Server data project in Pre Post Build section.
Hi Team, i am trying to connect postgres ODBC driver into SQL server data project to compare the Schema. Power Shell script is: ion Get-ODBC-Data{ param([string]$query=$(throw 'query is required.')) $conn = New-Object…
asked 2020-09-03T05:25:43.687+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, 90%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUM%3C/text%3E%3C/svg%3E)
Uma Mahesh U
1
Reputation point
commented 2020-09-08T07:37:46.407+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, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue (Shanghai Wicresoft Co., Ltd.)
34,271
Reputation points Microsoft Vendor
1 answer
Cannot connect Azure Data Catalog to Azure Database for PostgreSQL server
Hello, Can Azure Data Catalog (ADC) connect to Azure Database for PostgreSQL Server? I am using the local application for ADC. I am able to connect to other datasources like Azure Blob and SQL Database, to upload their metadata to ADC. …
asked 2020-08-19T04:03:54.607+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(22.400000000000002, 90%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Horniak, Peter
21
Reputation points
commented 2020-09-08T05:55:33.16+00:00
Horniak, Peter
21
Reputation points
1 answer
Changing wal_level configuration in Azure Database for PostgreSQL
According the the question Changing wal_level configuration in Azure Database for PostgreSQL referred from Debezium > Test with Postgres on Azure support for wal_level = logical max_wal_senders = 1 max_replication_slots = 1 was expected by…
asked 2020-09-07T10:35:40.82+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, 5%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEQ%3C/text%3E%3C/svg%3E)
Emanuele Quinto
1
Reputation point
answered 2020-09-07T11:39:01.543+00:00
Anurag Sharma
17,591
Reputation points
1 answer
Azure Postgres read-only replica creation via ARM templates is not idempotent
Hi, This is somehow related to the issue reported here enabling-replication-via-arm-template-not-idempotent I'm creating an Azure Postgres instance and a read-only replica for that instance using the ARM template attached to this question. When I…
asked 2020-09-04T12:50:40.69+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(236.8, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Petru Dumuta
11
Reputation points
commented 2020-09-04T22:40:38.437+00:00
Mike Ubezzi
2,776
Reputation points