Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
927 questions
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
![](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
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,221
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,221
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
1 answer
data encryption at rest in Azure Postgresql database
All managed dB services on azure have data encryption at rest by default. How to see the status on it for Azure postgresql.? Right now when I do "az postgres server show --name -g" of an existing postgresql server I can see Infrastructure…
asked 2020-05-06T14:01:23.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(176, 52%, 27%)' 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)
Aravind Kannan
6
Reputation points
commented 2020-05-20T02:26:51.717+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SSL Error when rebalancing after scaling Hyperscale cluster out
Title: SSL Error when rebalancing after scaling Hyperscale cluster out I scaled out an Azure Database for PostgreSQL Hyperscale cluster from 6 to 10 nodes. Scaling was initiated via the Worker Node count slider on the Configure page. There were no…
asked 2020-05-07T11:22:07.173+00:00
HitenBhavsar-MSFT
381
Reputation points Microsoft Employee
accepted 2020-05-07T22:02:21.68+00:00
HitenBhavsar-MSFT
381
Reputation points Microsoft Employee