Azure PG edit pg_ident.conf
I was wondering if it was possible to edit the pg_ident.conf file. I am hoping that a mapping will resolve the issue our application is having with the @hostname. I want to avoid changing the code. I can currently connect to Google PostgreSQL…
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…
PostgreSQL images on Azure VM (Please see screenshot below) -- Are they managed like azure does OS updates etc for them ?
When we try to create a VM in azure , we get several options for PostgreSQL. I wanted to know if the azure VM on Postgre in below screenshot are managed .i.e . OS updates are taken care by Azure etc.
Migration Postgresql to Azure database for Postgresql
May I know if there are option to do migration using dump and restore using incremental method to lower the down time ? pg_dump , pg_restore
Backup postgres database to Azure blob storage
Is it possible to backup Azure managed postgres instance database to Azure blob storage with life cycle management policy on top of it.
Do azure postgresql support roaringbitmap?
we need the roaringbitmap extention, but do not in the support extentions list
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…
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: …
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.
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…
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. …
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…
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…
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…
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 …
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…
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>…
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…
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…
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: …