Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
862 questions
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
![](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,571
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,571
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,571
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.)
29,891
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,571
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
6
Reputation points
commented 2020-09-04T22:40:38.437+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Cannot run stored procedures for postgreSQL in azure
I have to migrate my PostgreSQL from on-premise to the Azure cloud. I have stored procedures in the on-premise database. But I cannot find a way to run those on Azure Database for Postgresql. There is no option for PostgreSQL as a source for dataflows or…
asked 2020-09-01T13:11:15.027+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, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harditya Sarvaiya
1
Reputation point
commented 2020-09-04T13:36: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(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,216
Reputation points Microsoft Employee
1 answer
Updating a table based on values in the table
I have a temp table #XX that looks like this" ID KWID NAME ORDER 1447 1144 SW_6368_58_55.png NULL 1450 1145 SW_6942_58_55.png NULL 1451 1147 Arb3_43_55.jpg NULL 1452 1147 Arb1_43_55.jpg …
asked 2020-08-21T22:42:37.177+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, 23%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jim Seidel
61
Reputation points
commented 2020-08-25T05:01:39.593+00:00
Anurag Sharma
17,571
Reputation points
1 answer
Azure Database for PostgreSQL server truncates the same table repeatedly
Hi, I have a running PostgreSQL server on Azure. The server instance configuration is Basic, 2 vCore(s), 20 GB. My database has 10 tables in one schema. Among the 10 tables, the biggest table (11GB) has been truncated (become empty) repeatedly about…
asked 2020-07-16T19:50:08.583+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(44.800000000000004, 83%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Kim, Jisung
1
Reputation point
commented 2020-08-11T16:32:07.66+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to filter the access to Azure PostgreSQL by user+ip rather than just ip
I have already set firewall rules for Azure Postgresql and it works fine。 But i was told that in local Postgresql server，we can allow some users access in some clients by editting pg_hba.conf like this: hostssl <databaseName> <userName>…
![](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, 6%, 32%)' 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)
1 answer
Azure Analysis Service use postgresql as Data Source
Hello, I want to use the Azure Analysis Service (AS) with an on-premise postgresql database. To do this, I tried two approches : Create a tabular model on Azure AS. Migrate my local postgresql to Azure db for postgrsql. Then connect the Azure AS with…
asked 2020-07-28T12:55:03.637+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, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
ZDUAN
1
Reputation point
commented 2020-08-04T20:29:50.157+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, 9%, 23%)' 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)
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
Impossible to connect to a distant postgresql database
Hello, I want to use Power Bi in order to make a naturalist app with our postgresql database. I use this database on my computer with different softwares. I installed Npgsql-4.0.10 first as recommended. When I try to connect to my database, I got…
asked 2020-07-30T12:19:44.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(115.19999999999999, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mathias Broutin
1
Reputation point
commented 2020-08-03T17:06:14.33+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Connecting to Azure PostgreSQL server from python psycopg2 client
Hello, I have trouble connecting to the Azure postgres database from python. I am following the guide here - https://learn.microsoft.com/cs-cz/azure/postgresql/connect-python But the psycopg2 and SQLalchemy throw me the same error: …
![](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(108.80000000000001, 32%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Is Azure Postgres managed service hosted on Windows server or Linux?
We are using Azure postgres Managed server and ist shown as compiled by Visual C++ build 1800, 64-bit.We want to clarify which OS teh server is hosted on?
asked 2020-07-22T14:16:20.94+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
commented 2020-07-27T06:31:46.533+00:00
Honey Nadackal
126
Reputation points
2 answers
Backup stratergy for Azure PostgreSQL
I understand by default Azure keeps backups for PostgreSQL for upto 35 days. How can i increase that? Do i need to have a custom backup strategy if i want to maintain backup for more upto 7 years? I m new to PostgreSQL so details are appreciated.
asked 2020-06-04T22:13:42.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(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)
F Ahmed
36
Reputation points
commented 2020-07-08T22:13:05.7+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
The firewall rules in the Azure Database for Postgres do not allow any external connections
Hello, No matter what I do to set up the firewall to allow all traffic, I'm unable to access the database over pgadmin. Is this a currently known issue? Please see the firewall rules and the error I receive on pgadmin: ERROR: no pg_hba.conf…
asked 2020-06-27T02:16:50.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(9.6, 60%, 10%)' 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)
Shane McGraw
1
Reputation point
commented 2020-07-02T02:33:46.373+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
2 answers
how to use locale en_US.UTF-8 on azure postgresql
i try to create new database with locale en_US.UTF-8 but get error createdb -h serverName -p 5432 -U user@serverName --template="template0" -E UNICODE -O user "newDatabase"; i get bellow error: createdb: error: database…
asked 2020-06-17T09:33:39.327+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, 33%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
thuyerpacb
21
Reputation points
commented 2020-06-18T19:37:37.887+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Is there a way to know when a database was restored or created in postgre DBaaS?
Just that. I am trying to find a specific way, through the console, or with a query or the shell that would allow me to know if a database was restored accordingly. We have an automated process that restores from one environment to the other. I have…
asked 2020-06-08T13:53:27.44+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, 36%, 36%)' 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)
Alexsem
1
Reputation point
commented 2020-06-13T00:20:01.657+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
DB2 Migration from On premise to Cloud
Hi, Do Azure currently support running DB2 instance in Azure cloud Database ? If not, can we migrate using Azure Database migration services from DB2 to Azure Mysql or PostgreSQL etc. How long it will take to migrate ....let say we have 1700 tables ? …
asked 2020-05-26T11:06:06.167+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(179.20000000000002, 78%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBE%3C/text%3E%3C/svg%3E)
Boopathy, Elango
106
Reputation points
accepted 2020-05-28T03:44:59.037+00:00
Boopathy, Elango
106
Reputation points