215 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
1
answer
70
views
How to use Microsoft Entra ID for authentication with Azure Database for PostgreSQL in case of long running operations?
How to use Microsoft Entra ID for authentication with Azure Database for PostgreSQL in case of long running operations? I need to run pg_dump (I know there are other backup options available directly ...
-1
votes
1
answer
519
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 ...
-1
votes
1
answer
121
views
Azure Postgres flexible server - How to delete a user?
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 ...
0
votes
0
answers
98
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 ...
0
votes
1
answer
47
views
Is it necessary to carry out a Point-in-Time Recovery for both an original Azure database server and its read-only complement?
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 ...
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
0
answers
235
views
Manual backup of azure-postgresql database
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 ...
0
votes
1
answer
277
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 ...
0
votes
1
answer
70
views
Decrypt file encrypted with Azure Backup Vault
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 ...
1
vote
1
answer
276
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 ...
1
vote
1
answer
238
views
PgHero permission denied for function pg_stat_statements_reset in Azure
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 ...
0
votes
1
answer
215
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. ...
0
votes
1
answer
697
views
postgres upgrade and migration with no downtime
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 ...
0
votes
1
answer
167
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
0
answers
184
views
Unable to edit Azure PostgreSQL database created with Bicep
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 ...