Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.
Links:
Questions tagged [azure-postgresql]
171 questions
0
votes
1 answer
UserErrorMissingPermissionsOnSecretStore: Missing permissions to read the Key vault secrets
Hi I am creating vault back up for postgres database in azure. I deployed my terraform scripts as below.
resource "azurerm_data_protection_backup_vault" "abc-backup-vault" {
name = "abc-backup-vault"
resource_group_name =…
Niranjan
- 63
- 5
0
votes
1 answer
Azure PostgresSQL : Error: Code="FeatureSwitchNotEnabled" while trying to add VNET Rules
I am getting the following error while trying to add VNET Rules for Azure PostgresSQL database
│ Virtual Network Rule Name: "allow-app-service-access-0"): performing
CreateOrUpdate:
virtualnetworkrules.VirtualNetworkRulesClient#CreateOrUpdate:…
One Developer
- 99
- 5
- 43
- 103
0
votes
2 answers
Choosing the correct setup for a timeseries database
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…
Hannes
- 1
0
votes
1 answer
Python psycopg2 not able to connect to postgres server "psycopg2.OperationalError: FATAL: no pg_hba.conf entry for host, no encryption"
I am trying to connect to a postgres database from my python script using the psycopg2 library. But I am getting the following error
import psycopg2
conn = psycopg2.connect(host = , port = 5432, database = , user = ,…
sibiyes
- 61
- 7
0
votes
1 answer
Permission Denied when selecting data from a view with read-only access a newly created object in Postgres
I have a postgres SQL database which I created a readonly user and has read access to existing objects.
I created a view and now I need to give the read access to the view.
once I gave access to the view, it shows Permission denied for View..
This…
SOUser
- 31
- 3
0
votes
1 answer
Permission Denied on Select tables after giving Select permission to new user in Azure Postgres SQL single server database
I have Azure postgresql single server database which I need to give read permission to a newly created user.
CREATE USER "test@hostName" PASSWORD 'XXXX';
GRANT CONNECT ON DATABASE "test" TO "test@hostName";
ALTER DEFAULT PRIVILEGES
FOR USER…
SOUser
- 31
- 3
0
votes
1 answer
Flask API works correctly locally but returns 415 on Azure App Service
Current environment
Python 3.10
Flask 2.3.2 and waitress 2.1.2
Postgresql DB on Azure Postgresql managed service (flexible server)
App Service running docker container for the server with same requirements as above
Calling endpoints from python…
mattiatantardini
- 525
- 1
- 5
- 23
0
votes
1 answer
error installing python extension in postgresql
I have a postgresql database that is in production within azure, I want to install a python extension on this database
i use database manager called DBeaver
with it I run the command:
CREATE EXTENSION plpython3u;
but I get the error:
could not open…
Guilherme Rodrigues
- 321
- 6
0
votes
1 answer
Slow postgres query with long Bitmap Heap Scan "I/O Timings: read" time
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 (id) used for…
Happy Life
- 11
- 3
0
votes
1 answer
PostgreSQL - Keyset pagination query not working with UUID v4 searchAfter
I am trying to write a query to do keyset pagination.
But I see an unusual behavior here.
SELECT
p.id as Id,
p.first_name as FirstName,
p.last_name as LastName,
p.age as Age,
p.created_at as CreatedAt,
p.updated_at as UpdatedAt,
a.address as…
Kunal Mukherjee
- 5,775
- 3
- 25
- 53
0
votes
0 answers
Automating Azure Postgresql Restore
What I REALLY want to do is reset my postgresql db back to 4 hours prior (after my destructive DAST test runs), but I understand that is impossible, I can only restore to a NEW database. So I'll settle for some way to 'automate' this:
Restore 4…
DeannaD
- 1,469
- 2
- 16
- 27
0
votes
1 answer
How to create a read-only user in Azure PostgreSQL?
I'm trying to create a new user in postgresql which have read only access to Databases. I followed this document I will just list out the commands I used
CREATE ROLE readaccess;
GRANT CONNECT ON DATABASE db_name TO readaccess;
GRANT USAGE ON…
Alexy Pulivelil
- 87
- 10
0
votes
1 answer
logging custom messages in azure postgres
I my stored procedures, I have inserted custom raise messages like this:
raise warning 'proc executed for schema %',schema_name
I want to be able to view these logs as I execute these procedures, but, I wonder how to go about doing this. I did find…
mleko
- 102
- 7
0
votes
1 answer
Azure - Connection between App Service and Azure PostgreSQL Database using AD
I'm trying to establish a direct connection between an Azure App Service and an Azure Database for PostgreSQL single server.
I'm currently connecting to the database through a string connection and a user created in the database itself.
I need to…
Asfourhundred
- 3,003
- 2
- 13
- 18
0
votes
1 answer
How to assign multiple managed identities within Azure Web App for different AD users, linked to different Azure Flexible Postgres roles
I have an Azure Web App with AD authentication enabled for a single tenancy. I also have a Azure Flexible Postgres database with AD Authentication enabled.
I have set up two User-Managed-Identities (A & B) and two AD security groups (A & B). I want…
