Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.
Links:
Questions tagged [azure-postgresql]
171 questions
0
votes
2 answers
Data Masking in Azure data Factory
We are using Azure Data factory to move data from Source like Azure SQL and Azure Postgres to destination as Azure data lake.There is some sensitive data which needs to be masked.
Is it possible to have data masking in Azure Data factory during…
Himanshu Garg
- 1
- 1
0
votes
1 answer
CREATE SUPER USER in PaaS offering of Azure Database for Postgres?
i logged into the azure Postgres database , with the admin user credentials , that i gave at the time of creating the Azure Database for Postgres
Now when i try to create SUPERUSER , by giving the command
CREATE USER TESTER SUPERUSER; ---> it gives…
MSTechnie
- 175
- 10
0
votes
2 answers
Azure SQL Data sync
Use Case:I want to replicate data from my on Premises PostgreSQL database to my PostgreSQl database instance on Azure Cloud.This is not a one time replication/migration.This will be a periodic process.
1)Is Azure SQL Data sync compatible with…
AKANKSHA KUSHWAHA
- 53
- 1
- 6
0
votes
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 cluster…
Raja M
- 13
- 1
- 5
0
votes
1 answer
Data Migration Assistant for PostgreSQL to migrate to Azure PostgreSQL (not DMS)
Whenever we migrate on-premises SQL to Azure SQL , we can use Data Migration Assistant (DMA) for assessment (and also Data Migration Service (DMS) for migration)
I know that we have DMS which can help in migrating on-premises PostgreSQL to Azure…
MSTechnie
- 175
- 10
0
votes
1 answer
High Availability on Azure database for Postgres
As per document https://learn.microsoft.com/en-us/azure/postgresql/concepts-high-availability
for any failure/service down , automatically new service will deployed and re attach the storage to new server.
new service with same hostname/ip address…
revz
- 1
0
votes
2 answers
Azure PostgreSql restores
I have what seems to me at least an odd behavior when I'm dealing with a restored database from Azure Postgres. The end result seems to be that both the original and the restored server are linked meaning any change against the restored server is…
Paul Cavacas
- 4,194
- 5
- 31
- 60
0
votes
1 answer
How to add proxy to connect with Azure Postgresql?
I use this script to connect node.js with Azure Postgresql.
But the ssl verification of our firewall blocks the connection, so in the past I need to use a proxy. Where in the code can I add the proxy settings as like host and port?
Means when I…
Eden1998
- 119
- 1
- 11
0
votes
1 answer
Does Postgresql support Oracle's UTF-16?
I am working on migration of oracle-12c with utf16 to azure postgresql database.
While creating database in azure portal, I have to provide a collation name. Can someone please suggest with compatible (oracle utf16) collation name.
0
votes
1 answer
Azure Hyperscale (Citus) couldn't create database with the citus account
After creating the Azure Hyperscale (Citus) on the Azure portal, I use DbBeaver to access to the created database. I can connect to that database (succeed login to with the citus account and its password on the Azure portal), but when I tried to…
thangchung
- 2,020
- 2
- 17
- 28
0
votes
0 answers
Not able to connect Azure Postgres db from groovy snippet
I've Jenkins job to run groovy script which will import some data on Azure Postgres db. Here is my groovy part of postgress connectivity. I've added all the dependency classes in the groovy script.
def driver =…
Ahamed N
- 95
- 3
- 13
0
votes
1 answer
PostgreSQL rules in Azure automation
For a business case where I’m working on now I have a problem. I have A device which has to write on an Azure PostgreSQL server (https://azure.microsoft.com/nl-nl/services/postgresql/). The device has a dynamic DNS (creating a network or something…
Koen Verschuren
- 3
- 2
0
votes
1 answer
Azure Private Endpoint for PostgreSql Error with "Conflict" error
I am facing issues with the azure private endpoint for managed Postgres. To summarize I have been using Azure Managed Postgres and Private Endpoint already , but one day I accidentally deleted the "managed Postgres" service , Now in my setup I had 1…
vgdub
- 347
- 5
- 15
0
votes
1 answer
Azure functions integration with Postgres in Node.js
I want to access to Azure Postgres DB from an Azure function.
Below is the node.js source code of Azure function.
module.exports = async function (context, req) {
try {
context.log('Start function!');
var pg = require('pg');
const…
Michel Foucault
- 1,724
- 3
- 25
- 48
0
votes
1 answer
Does Azure Postgresql support table view replication?
I want to use replication only for table view which I have defined.
However, looking at online document , this seems to be not possible since server name and location is available for parameters.
Is it possible to only replicate table view using…
Yu Watanabe
- 621
- 4
- 17