214 questions
-1
votes
1
answer
392
views
How can you use the TimescaleDB extension with Azure Postgres Flexible server for Postgres v17.*
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 ...
- 4,014
0
votes
0
answers
86
views
How to call database function followed by VACUUM in cron job
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 ...
- 27.8k
0
votes
1
answer
56
views
Postgresql flexibleserver is failing with "AttributeError: 'FlexibleServerCapability' object has no attribute 'supported_features'" from Azure CLI
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 ...
0
votes
1
answer
260
views
Azure PostgreSql Flexible Server - Admin to database [closed]
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 ...
- 221
1
vote
1
answer
254
views
Getting permission denied while running query in azure PostgreSQL flexible server
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 ...
- 17
0
votes
1
answer
200
views
Connect to Azure Postgresql Flexible server Database from Nestjs using any ORM
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. ...
- 1
0
votes
1
answer
152
views
Not able to do geo restore in same region of azure postgres flex server using terraform
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 ...
0
votes
1
answer
130
views
How to find out which API to use in ARM Template to provision Postgresql flexible server
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 ...
- 1,773
1
vote
1
answer
644
views
PostGreSQL pg_dump psql and pg_restore errors with Azure Flexible SQL Server
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 ...
- 1,312
0
votes
1
answer
237
views
Visualize Azure PostgresSQL table data
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 ...
0
votes
1
answer
399
views
Terraform obtain IP of azure postgres flexible server
I have a Postgres flexible server deployed using private networking:
resource "azurerm_subnet" "vnet_subnet_postgres" {
name = "my-subnet"
...
- 153
0
votes
1
answer
157
views
Azure PostgreSQL Flexible Server - set log_statement for specific user only
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 ...
0
votes
1
answer
394
views
azure flexible server migration failing with collation UTF8
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 ...
- 1
0
votes
0
answers
157
views
Managed Migration Service of Azure Postgres Sibgle Server to Flexible server
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 ...
1
vote
1
answer
1k
views
How to connect from pgadmin to postgreSQL server with private endpoint in azure?
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 ...
- 3,991
1
vote
0
answers
185
views
How to achieve list partitioning in Azure Postgres flexible server?
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 ...
- 1,713
1
vote
1
answer
388
views
Syntax error when running materialized view refresh concurrently in Azure Flexible Server for PostgreSQL
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 ...
- 105
0
votes
1
answer
443
views
Sent the Postgresql query result to Log Analytics workspace to create custom metric in Azure Monitor
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 ...
- 13
0
votes
1
answer
172
views
How to get Connection String in Azure Function?
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 ...
- 578
0
votes
1
answer
458
views
Azure DB for Postgres not accessible from Azure App Services
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 ...
- 982
0
votes
1
answer
734
views
Unable to create ADF Linked Service for Azure Cosmos DB for PostgreSQL Cluster
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 '...
- 27
0
votes
1
answer
747
views
Error while running PostgreSQL command from terrafrom local-exec
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 ...
- 743
0
votes
2
answers
3k
views
azure postgresql database with azure entra id
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-...
- 743
1
vote
1
answer
1k
views
Trying to add local IP to Azure PostgreSQL server but getting getaddrinfo ENOTFOUND
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 ...
- 364
0
votes
1
answer
296
views
How does the locale setting change affect on upgrading PostgreSQL server on Azure?
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 ...
- 13