Skip to main content
214 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-1 votes
1 answer
418 views

I am attempting to use the TimescaleDB extension with Azure Postgres but I keep getting this error Because timescaledb isn't a trusted extension, only members of "azure_pg_admin" are ...
MRainzo's user avatar
  • 4,014
-1 votes
1 answer
116 views

Using my "globalAdmin" account (which is not a pg superuser) I create a user via CREATE ROLE myDatabase_IntegrationServicesAccount LOGIN WITH PASSWORD 'test@12345' and if I SELECT * FROM ...
Leonardo's user avatar
  • 11.5k
0 votes
0 answers
87 views

I want to schedule some database maintenance that consists of deleting old data followed by VACUUM: CREATE EXTENSION IF NOT EXISTS pg_cron; SELECT cron.schedule('cleanup', '* * * * *', ' CALL ...
Liero's user avatar
  • 27.8k
0 votes
1 answer
46 views

Given that: You have an Azure subscription. Within that subscription, you have an "Azure Database for PostgreSQL flexible server" - call this Server A. Within the same subscription, you ...
Tom Hosker's user avatar
  • 744
0 votes
1 answer
56 views

I am very new Azure and I have an OpenSUSE vm with latest AZ CLI 2.71.0 installed. I am trying to create Postgresql Flexible server through cli with the below command az postgres flexible-server ...
Manohar Amkem's user avatar
  • 35
0 votes
0 answers
210 views

I have a managed postgresql database. I now want to replicate this on a VM with pg_dump and pg_restore (the purpose is not mainly backup, but rather to have a cheap recently-up-to-date staging and ...
user422005's user avatar
  • 2,091
0 votes
1 answer
260 views

Is it somehow possible to have an admin user in Azure PostgreSql who has rights over all objects - he can read write, but can also alter, delete or give rights to others etc? It seems to me that this ...
pietro's user avatar
  • 221
0 votes
1 answer
69 views

I have a backup vault in Azure that store long term backups of my Azure Database for PostgreSQL - Flexible Servers. Problem is that I can't restore the backups. When I restore the backups in the ...
zoptop's user avatar
  • 11
1 vote
1 answer
258 views

Firstly I have been created a PostgreSQL 16 database on azure flexible server and then I login with the admin account and trying to use postgresql-anonymizer to mask the data but while following the ...
haxkd's user avatar
  • 17
1 vote
1 answer
222 views

I dumped and restored my database from AWS RDS to Azure Database for PostgreSQL - Flexible Server (PostgreSQL version 14.13) and even though PgHero used to work correctly, in Azure it throws ...
Fotis Papadamis's user avatar
  • 303
0 votes
1 answer
204 views

We are builing a nestjs application that connects to Azure Postgresql Flexible Database server using Typeorm. We are following the passwordless apparoach using managed identity and using Entra token. ...
amn's user avatar
  • 1
0 votes
1 answer
661 views

I am looking forward to upgrade azure Postgres flexible from version 12 to 16. I can do it with downtime using pgdump but I want to do it in a way that there is no downtime. Postgres sql is in azure ...
Waseem Mir's user avatar
  • 303
0 votes
1 answer
163 views

I am trying to do restore of azure flexible postgres server on which geo redundant backup is enabled. From azure portal I am able to restore in same region. But from terraform I am getting error while ...
swapnil_bharata's user avatar
  • 3
0 votes
0 answers
173 views

I have an Azure PostgreSQL Flexible Server and a database 'mydb' created with Bicep and Github Actions. When creating a database with Bicep, the database owner is set to the 'azuresu' role which is ...
Lazer's user avatar
  • 601
0 votes
1 answer
131 views

I created a bicep script to provision out a Postgresql Flexible server. I then build the script and output an ARM template to use in Azure Portal. The deployment fails with the following errors. No ...
Ed Mendez's user avatar
  • 1,773
0 votes
1 answer
653 views

I have deployed an azure postgresql flexible server using terraform. The terraform code is in a submodule and I include it in the main.tf like this: module "postgresql" { source ...
Fabry's user avatar
  • 1,650
1 vote
1 answer
655 views

I am trying to dump and then restore PostGreSQL databases using Azure PostGreSQL Flexible. I am using pg_dump and psql previously for these purposes. I have been succesfully using following commands ...
london_utku's user avatar
  • 1,312
0 votes
1 answer
137 views

I am trying to connect to Azure PostgreSQL to Power BI Service to create dashboards/reports. However, I can't find option to connect to Azure postgreSQL after navigating to Get Data option (green ...
user-stackoverflow's user avatar
  • 1
0 votes
1 answer
241 views

We have data stored in different tables in azure postgresql database. Now, we want to create dashboards/reports for our clients to visualize/analyze this data (preferably in azure). I am new to this ...
user-stackoverflow's user avatar
  • 1
0 votes
1 answer
73 views

I encountered an issue while using Azure Synapse's Lookup Activity to call a stored procedure that deletes records from a table. Despite the activity completing almost instantaneously, no records were ...
user15382501's user avatar
  • 31
0 votes
1 answer
405 views

I have a Postgres flexible server deployed using private networking: resource "azurerm_subnet" "vnet_subnet_postgres" { name = "my-subnet" ...
Eddy's user avatar
  • 153
2 votes
1 answer
540 views

I'm trying to deploy a PostgreSQL database via ARM template, along with around 33 config changes during deployment. Some of the configurations are updated but the rest fail with '<server>' is ...
thmswlkr's user avatar
  • 83
0 votes
1 answer
157 views

Is there any way to set log_statement for specific user in Azure PostgreSQL Flexible Server? Normally it should be like: ALTER ROLE user_login SET log_statement TO 'all'; but due to access restriction ...
user26422324's user avatar
  • 1
0 votes
2 answers
1k views

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/...
Eddy's user avatar
  • 153
0 votes
1 answer
402 views

we're testing migration of postgres running on a VM to azure flexible server using the migration option in the portal. On the validation it fails saying Error 603401: Collation mismatch. Collation ...
DNA's user avatar
  • 1
1 vote
2 answers
295 views

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 ...
Roberto Hernandez's user avatar
  • 8,583
0 votes
0 answers
157 views

I have been trying to migrate a database hosted in Azure PostgreSQL single server to Flexible server using the managed migration service provided. The migration fails with Foreign Key Constraint ...
mukut bhattacharjee's user avatar
  • 311
0 votes
2 answers
521 views

I'm using an Azure PostgreSQL database and need to perform a point-in-time restore (PITR) as part of a disaster recovery drill. I can successfully restore the database to a new server and update my ...
Kamal Rathnayake's user avatar
  • 582
1 vote
1 answer
1k views

I just want to connect from my local host machine(pgadmin) to a azure postgreSQL database with private endpoint So I have created a postgreSQL flexible server and I have choosen for the option Public ...
mightycode Newton's user avatar
  • 3,991
5 votes
0 answers
1k views

I have been working on granting a read-only rights to a certain role within Postgres-flex v16, but that doesn't work. I login with my Azure admin account on the postgres-db server for creating a new ...
Am_I_Helpful's user avatar
  • 19.2k
1 vote
0 answers
185 views

I'm using Azure Postgres flexible server and now I want to implement table partition by several values in a column. I went through pg_partmen(v4.7.1) extension docs and seems it doesn't support list ...
Shirantha Madusanka's user avatar
  • 1,713
0 votes
2 answers
3k views

I am new to Azure function as well as python. I have created a Azure function using python v2 programming model and I can execute it successfully from VS code. But when try deploying either using VS ...
Sivanesan's user avatar
  • 3
1 vote
1 answer
393 views

I'm encountering a syntax error when attempting to refresh a materialized view concurrently in Azure Flexible Server for PostgreSQL v11.22. REFRESH MATERIALIZED VIEW CONCURRENTLY data.mv_summary WITH ...
praveen's user avatar
  • 105
4 votes
1 answer
7k views

I have created the Azure Postgres SQL Server and Web app with docker image following the official site of Wiki JS installation: https://docs.requarks.io/install/azurewebapp Configured the web app with ...
VivekAnandChakravarthy's user avatar
  • 847
0 votes
1 answer
452 views

I want to schedule to run a Postgresql query and Azure Monitor will generate a custom metric based on that query result then trigger an email if result return 1. I don't know how to send the SQL query ...
Hieu Hoang's user avatar
  • 13
0 votes
1 answer
322 views

I'm looking for a possible solution to connect dbt Cloud to an Azure PostgreSQL server hosted in a private vnet. I couldn't find a direct answer in dbt documentation. I am thinking about deploying a ...
Jan R's user avatar
  • 1
0 votes
1 answer
172 views

I have an Azure Function and a PostreSQL DB in Azure Cloud. From my Azure Function I want to access the Connection String, let's call it IT-PostgreSQL. This is my Azure Function: namespace ...
Shury's user avatar
  • 578
1 vote
1 answer
3k views

I am trying to create users with names same as that of the DB in postgres flexible server using terraform. The user creation code is as below. resource "...
bittus's user avatar
  • 15
0 votes
1 answer
461 views

I'm running a Dotnet Web API in a container on Azure App Services (Free tier plan). In my application, I check the POSTGRES_CONN_STRING environment variable and then use it as a connection string for ...
skynyrd's user avatar
  • 982
0 votes
1 answer
484 views

I have an old application which uses Npgsql Version 4.1.12 I am connecting to an Azure database which requires an SSL connection. I can connect to the database using the string: Server=xxxxx.postgres....
Daniel Gee's user avatar
  • 438
0 votes
1 answer
734 views

I am facing issue when creating a linked service from ADF for Azure Cosmos DB for PostgreSql CLuster.. Please help me to resolve the issue. Note: Cluster is running. In the cluster in Networking '...
Abhijit's user avatar
  • 27
0 votes
1 answer
900 views

I'm currently integrating our database with the Azure PostgreSQL Flexi server in the cloud. I've successfully set up the server on the Azure platform, but I'm encountering connectivity issues when ...
Siyamcela Nxuseka's user avatar
  • 1
0 votes
1 answer
749 views

I am trying to run some PostgreSQL command after creating the PostgreSQL. First I tried to run the psql command line on my command prompt and it works. See below screenshot The same I would like to ...
Ravi Khambhati's user avatar
  • 743
0 votes
1 answer
3k views

I am using Azure Database for PostgreSQL flexible server. Here is what I am doing. Please let me know where I am going wrong. Create a new PostgreSQL flexible server(With both authentication ...
Ravi Khambhati's user avatar
  • 743
0 votes
2 answers
3k views

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-...
Ravi Khambhati's user avatar
  • 743
0 votes
1 answer
2k views

I have tried any solution I have found here so far, however not a single one solved my issues of not being able to insert data into azure Postgres using psycopg2. This is the sample dict I have and ...
paul445's user avatar
  • 71
1 vote
1 answer
1k views

I'm using Azure App Service which created an Azure Database for PostgreSQL flexible server and I keep getting this error when trying to add my local IP to the firewall throught the Azure extension on ...
code writer 3000's user avatar
  • 364
0 votes
1 answer
767 views

Postgres flexible server running on Azure. Postgis extension was installed to the dbo schema using create extension postgis schema dbo; which also contains the core data tables. Under extensions in ...
Nick's user avatar
  • 70
0 votes
1 answer
296 views

I am going to upgrade PostgreSQL server from "Single Server" to "Flexible Server"(version 13) due to some business requirements. According to the Azure's doc, the Flexible Server ...
Masakorelab's user avatar
  • 13
2 votes
2 answers
7k views

I've created a Azure Database for PostgreSQL flexible servers inside a virtual network, with a dedicated subnet for the database set to flexible servers. I've got a Private DNS Zone as well with an A ...
sgw's user avatar
  • 31

1
2 3 4 5