Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
847 questions
1 answer
Azure Django PostgreSQL deploy: Database migration does not work as it should
I am trying to deploy my Django App on Azure with python runtime 3.8 and a PostgreSQL database. I followed the tutorial on microsoft learn (using the web + database experience) , and have structured my app similar to the example.Including a migration of…
asked 2022-10-24T20:24:51.47+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, 88%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nick Mol
1
Reputation point
commented 2022-11-01T20:50:16.963+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to Link A Reserved Postgres DB To A Newly Created Postgres Db
Hi, I have reserved a postgres db single server on azure. I wont to use this reserve instance to launch a new postgres DB but can't see my way around it. Any help will be really appreciated. Thanks.
asked 2022-10-31T19:33:54.463+00:00
cloudwithdeb
41
Reputation points
commented 2022-10-31T23:27:24.197+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
0 answers
Postmaster has commanded server process to rollback the current statement and exit in repica server created by PgLogical
Team, I am Facing below mentioned error in Postgresql flexible server when two subscriptions are created. WARNING: 57P02: terminating connection because of crash of another server process","detail": "The postmaster has…
asked 2022-10-21T13:32:37.457+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, 21%, 21%)' 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)
Mani Mahesh Sivakumar
56
Reputation points
commented 2022-10-28T17:54:55.197+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure migration of DDL and DML from MySQL to PostgresSQl instance
Hi, I would like to know if Azure has an easy way to migrate the data and the database structure from MySQl to PostgresSQL.
asked 2022-10-19T16:23:49.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(284.8, 76%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Claudio Resende
221
Reputation points
commented 2022-10-26T13:15:13.573+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
How to overcome unavailablity of replication slots in HA standby in Postgres Flexible server
As Per our client recommendation, we need to have read replica in our db architecture. We are using Postgres Flexible server in HA setup. For creating read replica, we have done POC on logical replication using pg_logical . As there is limitation of…
asked 2022-10-03T06:42:56.553+00:00
Mani Mahesh Sivakumar
56
Reputation points
commented 2022-10-21T16:21:21.32+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
0 answers
Outdated linux alpine image used in /azure-oss-db-tools/pgbouncer-sidecar:latest docker image
Hi team, I am using this docker image - mcr.microsoft.com/azure-oss-db-tools/pgbouncer-sidecar:latest (https://hub.docker.com/_/microsoft-azure-oss-db-tools-pgbouncer-sidecar) I am using this image in pgbouncer-sidecar-container for the…
asked 2022-10-15T08:46:21.107+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, 60%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shubham Pawar
1
Reputation point
commented 2022-10-20T15:39:38.903+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Regarding ZRS redundancy of Backup Storage for Azure Database for PostgreSQL (Flexible Server), is a replica created for ZRS? [2210170060000616]
Hello Team, Regarding back up costs for Azure Database for PostgreSQL (Flexible Server). When setting the availability of the Backup to GRS, the Storage cost becomes double that of LRS. In the pricing page of flexible server:…
asked 2022-10-17T21:10:38.42+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, 41%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Peter Thurwachter (MINDTREE LIMITED)
621
Reputation points
accepted 2022-10-19T23:02:47.047+00:00
Peter Thurwachter (MINDTREE LIMITED)
621
Reputation points
0 answers
Application timesout after around 10 mins but runs perfectly locally./
Python FastAPI app, that uses SQLAlchemy for connecting to a PostgreSQL DB. The app spins up, but after less than 10min it is not reachable anymore. (1) /health -> health check that does a “SELECT 1;" on the database to see if Postgres…
asked 2022-10-13T03:57:02.993+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(192, 26%, 28%)' 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)
SupportProfSwo
31
Reputation points
commented 2022-10-18T10:24:57.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(185.6, 59%, 27%)' 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)
SnehaAgrawal-MSFT
18,196
Reputation points
1 answer
One of the answers was accepted by the question author.
Permission denied for schema cron
Hi there! I am trying to configure the pg_cron extension on our postgresql 13 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. I've added pg_cron to the…
asked 2022-09-28T12:46:36.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(137.6, 89%, 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)
Sokkenissen
31
Reputation points
commented 2022-10-17T14:18:34.973+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
2 answers
Purview access postgresql Error: (3912) Connector Exception
I try to scan a Azure Postgresql database in Azure purview but receive this message: "Error: (3912) Connector Exception: Unable to access the with the given credentials." The Purview account have the get and list in secret permission. …
asked 2022-09-30T14:40:30.497+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, 24%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Eduardo Evangelista
1
Reputation point
commented 2022-10-13T19:47:25.373+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to fetch flexible server(providers/Microsoft.DBforPostgreSQL/flexibleServers/) configurations in java?
I have a requirement to fetch/update(through java SDK) flexible server configurations for which rest APIs are already available. But, only server options are available from java SDK. And I was getting a 404 error every time I try to get configurations…
asked 2022-10-06T11:14:18.67+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, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tasleema Shaik Mohammed
71
Reputation points
commented 2022-10-12T14:54:51.103+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(204.8, 44%, 29%)' 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)
Saurabh Sharma
23,671
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Data encryption keys managment
Hi all, I'm trying to understand if with flexible postgreSQL Database, volume encryption can be configured in a way in which keys are managed by me and not by the system, using a key vault or something similar... I've found that encryption (similar…
asked 2022-07-13T11:43:38.783+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(224.00000000000003, 85%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOS%3C/text%3E%3C/svg%3E)
Oprandi, Simone
21
Reputation points
commented 2022-10-12T05:55:34.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(214.4, 38%, 30%)' 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)
Julian Schallenmüller
1
Reputation point
0 answers
Azure Postgresql stuck in restart state for long time
Hello, Our Azure Postgresql usage was stuck at 100% unexpectedly. I restarted it to resolve this but it is still in restarting state after an hour. What can be done to bring it online? Thanks.
asked 2022-10-08T15:22:13.52+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, 44%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Shahbaz Ali
1
Reputation point
commented 2022-10-11T21:11:15.1+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
0 answers
I recently created a VPS from South Africa North region but currently it's not available
I recently created a VPS from South Africa North region but currently it's not available
asked 2022-10-08T04:37:09.647+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, 6%, 17%)' 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)
Fic
1
Reputation point
commented 2022-10-11T18:54:44.04+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Permission denied for sequence jobid_seq when trying to do a pg_dump
Hi! I am trying to perform a backup of my database in Azure Database for PostgreSQL flexible server into my machine. I have tried using pg_dump and also doing a backup through the pgAdmin client, however, in both cases I get 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(208, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to create role in citus DB using bicep + pipeline
Hello, I have created a Citus database via pipeline + bicep file. At this point I would like to automate the creation of roles in this database. Maybe with an inLinescript of sorts. So far, all the lead I found points to this link…
asked 2022-10-06T19:22:10.237+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, 20%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYX%3C/text%3E%3C/svg%3E)
Yan Xue
21
Reputation points
commented 2022-10-10T17:17:00.843+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
2 answers
Alter system function to immutable in Azure PostgreSQL - Flexible Server (PostgreSQL 14)
I am trying to create below index in Azure PostgreSQL Flexible Server (PostgreSQL version 14) with admin user CREATE INDEX index_name ON table_name USING btree (to_char(columnname, 'YYYYMM'::text)); NOTE - Column data type in table is…
asked 2022-09-26T09:18:09.653+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
commented 2022-10-07T20:29:42.947+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
0 answers
Backup Vault for PostgreSQL Flexible Server
Hi, PostgreSQL Flexible Server went GA on 01/12/2021. https://twitter.com/AzureDBPostgres/status/1465719405707292673 When will I be able to use azure Backup Vault for PostgreSQL Flexible Server ? …
![](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(124.80000000000001, 34%, 22%)' 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)
0 answers
Cannot Drop Azure Data Factory Temporary Staging Tables
I'm using ADF to copy data from on-prem Postgres to Azure Postgres. I'm copying to a temp table in Azure Postgres. From the temp table I then perform an Upsert using Azure Data Factory to then load the data into another Azure Postgres table for…
asked 2022-10-04T18:55:39.347+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, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kyle Bender
21
Reputation points
commented 2022-10-06T21:05:33.433+00:00
GeethaThatipatri-MSFT
27,012
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Upsert fail on second attempt
I'm trying to upsert all data from a temp table to a prod table using Azure Postgres. On the first attempt, the upsert from temp to prod worked but there was no data in the prod table, just a schema. On second attempt, when there is data in both temp and…
asked 2022-09-15T18:52:51.533+00:00
Kyle Bender
21
Reputation points
accepted 2022-10-05T14:59:47.593+00:00
Kyle Bender
21
Reputation points