Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
888 questions
0 answers
PostgreSQL Bulk Copy with PowerShell
Hello folks! I sure hope you're having a kick ass weekend! This is my first of hopefully many posts here and i have to admit it was a bit of a click bait. There is no Bulk Copy on PostgreSQL that i know and like any good guy who's just starting to…
asked 2021-05-23T17:43:26.363+00:00
Francisco Nabas
31
Reputation points
commented 2021-05-27T02:20:22.66+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 create PostgreSQL project in Visual Studio 2019?
How to create a PostgreSQL database project in Visual Studio 2019 as like we are doing SQL DB Project????. Visual Studio has provided SQL Database project template but I didn't find anything for PostgreSQL Database. We are using AzureDevops + GITHUB…
asked 2021-05-19T09:03:37.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(313.6, 5%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vinod Bhoite
6
Reputation points
commented 2021-05-25T06:03:55.53+00:00
Vinod Bhoite
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Replication solution between on-premise PostgreSQL and Azure database for PostgreSQL
My client wants to replicate their on-premise PostgreSQL database and Azure Database for PostgreSQL. The on-premise database is a master and Azure is a slave(read-only). My client wants to sync data in minimum time(etc, 1min).
asked 2021-05-12T20:30:27.663+00:00
Mohsen Akhavan
936
Reputation points
accepted 2021-05-20T05:09:47.453+00:00
Mohsen Akhavan
936
Reputation points
1 answer
Hi i have a question. For the "Upgrade your Azure Database for PostgreSQL from version 9.6 to 11" notification. Does this impact South Africa regions as i dont see it in the "IMPACTED SERVICE(S) AND REGION(S)" list ?
This is the Notification that i received from Azure: You're receiving this notice because you are using Azure Database for PostgreSQL version 9.6. Because PostgreSQL version 9.6 community support ends on 11 November 2021, Azure Database for…
asked 2021-05-18T07:50:11.623+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, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vinesh Singh
1
Reputation point
answered 2021-05-18T10:25:55.893+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
How to pass file path from Azure Storage into your Azure stored procedure
Hi, I have written a stored procedure that reads data from csv file and put it into multiple Postgres tables. It requires file path as a parameter and locally it works perfectly. Call myProcedure('c:\file.csv'); // this works fine locally. I have…
asked 2021-05-14T16:12:31.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(22.400000000000002, 9%, 12%)' 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)
Atul Kaushal
1
Reputation point
answered 2021-05-17T07:11:10.56+00:00
Sumarigo-MSFT
44,001
Reputation points Microsoft Employee
1 answer
How to connect two Azure postgreSQL Databases on different hosts with a postgre_fdw
Hello, I'm trying to connect my Azure DB to another Azure DB on a different host using postgres_fdw. I receive an error: ERROR: could not connect to server "********" DETAIL: could not connect to server: Network is down (0x00002742/10050) …
asked 2021-05-10T14:25:51.233+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(118.4, 0%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vitalii Manoilo
1
Reputation point
commented 2021-05-13T03:50:00.007+00:00
Vitalii Manoilo
1
Reputation point
1 answer
One of the answers was accepted by the question author.
how to access and read archived postgresql logs from blob storage ?
We have made diagnostic settings in one of our azure postgresql server to archive postgresql logs into the storage account. But when we exploring the storage using storage explorer is showing into muliple folder hirearachy like…
asked 2021-04-29T05:13:06.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(160, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sabir Laskar
21
Reputation points
accepted 2021-05-05T12:40:03.18+00:00
Sabir Laskar
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure PostgreSql Tuning
Hi, I using the Azure Postgres and need changes settings to Tuning the Postgres, but not access a some importante properties. Changing this properties checkpoint_completion_target, effective_cache_size, maintenance_work_mem,…
asked 2020-08-10T13:26:30.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(0, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Marcia Rodrigues
136
Reputation points
commented 2021-04-27T16:38:51.953+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(185.6, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ricardo Camacho
1
Reputation point
1 answer
One of the answers was accepted by the question author.
On prem DB2 Migration to PostgreSQL in Azure
Hi, Does Azure migration service migrate DB2 instance in on prem to PostgreSQL in Azure. How long it will take to migrate Let say we have 1000 tables ? Or only we have an option of provisioning a VM and running DB2 instance (Rehost strategy) ? …
asked 2021-04-20T09:59:07.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(300.8, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
V R Venuu Maadhav
21
Reputation points
accepted 2021-04-20T12:40:18.983+00:00
V R Venuu Maadhav
21
Reputation points
2 answers
One of the answers was accepted by the question author.
ANALYZE command in azure database for postgresql
Hi Team, Looking for some inputs on the below. We are in the process of moving our on premises postgres v10 to azure database for postgresql(v11) single server. Do we need to manually run ANALYZE on all tables on the PAAS platform (azure database for…
![](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)
1 answer
PostgreSQL Private Endpoint - Resource Not Supported
I'm having issues creating a private endpoint to my postgreSQL service. I created a basic Azure Database for PostgreSQL Server instance and spun up a test vm. I enabled the Allow access to Azure services option in connection security. When I go to…
asked 2021-03-19T16:02:07.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(160, 28.000000000000004%, 25%)' 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)
Michael Smith
1
Reputation point
commented 2021-03-22T21:25:26.41+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Parse az postgres server show
Hi,Currently, this is the JSON for 'az postgres server show'. I want to know how I can use this JSON to parse for minimal-tls-version ? { "administratorLogin": "myadmin", "earliestRestoreDate": null, …
asked 2021-03-09T17:12:25.18+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, 22%, 32%)' 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)
Sara
1
Reputation point
commented 2021-03-17T07:41:33.867+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,576
Reputation points
1 answer
42601 : syntax error at or near "'Microsoft.ACE.OLEDB.12.0'"/
Hello, I am getting this error while I am running my code.(42601 : syntax error at or near "'Microsoft.ACE.OLEDB.12.0'"/) using (var conn = new NpgsqlConnection(configuration.SqlServerConnectionString)) { conn.Open(); var command =…
asked 2021-03-15T03:28:24.74+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, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sivakrishna k
1
Reputation point
commented 2021-03-16T07:22:48.61+00:00
Anurag Sharma
17,576
Reputation points
1 answer
Azure database for Postgresql - SSL enabling
Hi, We are using Azure database for Postgresql and application is hosted in Azure private cloud. By default Postgresql enforces SSL to be enabled, so have used so in the connection string have used sslmode=require. …
asked 2021-03-12T18:21:39.033+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(131.20000000000002, 30%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ramkumar Sarva Radhakrishnan
1
Reputation point
commented 2021-03-16T00:31:20.377+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
consuming azw postgres server list variable
Hi, I want to query azw postgres server list and I understand, one of the parameters is "query". Can I know how I can consume the value of "minimal-tls-version" in my local variable? Something like this: db_version=$(azw postgres…
asked 2021-03-09T06:58:51.663+00:00
Sara
1
Reputation point
commented 2021-03-10T13:33:22.447+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Data Factory : Self hosted IR fails to connect to Azure PostgresSQL
Hi, We are trying to move data from Postgres DB running on On-Prem using Azure data factory copy data activity. We have installed Self hosted IR (SHIR) on one of our On-Prem machines. We are able to run lookup activity which connects to this On-Prem…
asked 2021-01-15T14:56:47.39+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, 28.000000000000004%, 38%)' 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)
Manjusha
21
Reputation points
commented 2021-03-04T06:17:05.787+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(70.4, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sonam Jain
1
Reputation point
1 answer
JSON funtion and operator support in Azure Database for Postgresql
Does Azure database for PostgreSQL support json function and operator? I have postgre dB installed on the VM where I am heavily using Json functions and opeartors, but, on migration of the dB to Azure database for PostgreSQL I noticed that none of my…
asked 2021-02-28T03:04:06.01+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, 33%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NavNig
1
Reputation point
commented 2021-03-03T06:29:32.597+00:00
Anurag Sharma
17,576
Reputation points
1 answer
How to put the first element of csv string into the last column in Postgres.
I have a column with comma-separated values and I want to split it into fixed-size columns. I have used the split_part function to do so but the values in columns should appear from the right side. Example: Table with a single column a1, b1, c1 a2,…
asked 2021-02-23T13:00:57.597+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, 86%, 10%)' 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)
Martin1920
1
Reputation point
answered 2021-02-27T02:31:42.657+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Upgrade Postres Azure version
Hi My connect select version() ; PostgreSQL 10.11, compiled by Visual C++ build 1800, 64-bit My collegue has select version() ; PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bit PostgreSQL 11 support Stored Procedures How can…
asked 2020-11-19T15:30:54.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(163.2, 3%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Fiodar Hulin
21
Reputation points
accepted 2021-02-24T09:14:52.693+00:00
Fiodar Hulin
21
Reputation points
1 answer
One of the answers was accepted by the question author.
PostgreSQL 12 Flexible Server
Hello we are planning to upgrade our postgresql 9.6 azure to a new version, since the EOS est 2021/11. we wish to upgrade to Postgresql 13 or at least 12. but posqtgreSQL 13 is not availble and 12 is only availble as Flexible Server and it is…
asked 2021-02-22T13:26:22.34+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(108.80000000000001, 35%, 20%)' 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)
SHABOU Malek
46
Reputation points
accepted 2021-02-23T14:21:39.463+00:00
SHABOU Malek
46
Reputation points