I am trying to connect from Azure data factory to a Postgres Flexible server. I sticked to the official Microsoft documentation to achieve it: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-to-data-factory-private-endpoint I had a identical setup with a postgres single server which worked, however, using the…
I have a Postgres 14 running in Azure Flexible Server. The server has the extension pg_audit enabled. I am using a psql client version 12 installed in a Linux machine. I've used pg_restore to restore a lot of schemas and…
I am going through below documentation which shows various ways to authenticate Azure PostgreSQL database with Azure Entra ID https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-configure-sign-in-azure-ad-authentication#creating-microsoft-entra-users-in-azure-database-for-postgresql In section named "Creating Microsoft Entra users in Azure Database for PostgreSQL" it suggest to run below command but I…
I'm seeking advice on how to optimize my timeseries database setup, which should handle a large volume of time-series data. I have around 20,000 time-series profiles with a one-year duration, using a quarterly time resolution (4 timestamps per hour). This…
Hi I have a database with 10 tables. each table has ~0.5-1 billion rows, and partitioned by range and then hash (10x10=100 partitions). they are newly created tables, and import data from csv files. they are indexed on the column…
I had migrated from Heroku to Microsft Azure, and the speed is really very slow, my App service is having the following specs OS (linux): P1V2 210 total ACU 3.5 GB memory Dv2-Series compute equivalent then when it comes to…
I have enabled Azure Postgresql SSL connection mode and after doing that I was not able to connect to Postgres database using dbForge, it is showing that SSL connection is required. Please specify SSL options and retry. I can able…