Azure Database for PostgreSQL resource not showing up in Azure portal
We have a postgres database, it is present in the subscription invoices. It is available for applications, but it is not visible in the resource group and is not visible anywhere except in the payment invoices.
Azure Database for PostgreSQL - Flexible Server: Setting Session Replication Role in JDBC Options
Is it possible to set the session replication role in JDBC options for Azure Database for PostgreSQL - Flexible Server (Postgres v13)? While I was able to execute SET session_replication_role = 'replica' directly in the database, I encountered an error…
locate PostgreSQL databases exact location
locate PostgreSQL databases exact location in Azure's North European regions For GDPR compliance status. Azure Database for PostgreSQL - Flexible Servers GDPR compliance status based on region Resource group aoih-prod Subscription…
Postgre-SQL Flexible Server - pg_cron permissions issue
I am connecting to the postgres database with the psqladminun user who is a member of the azure_pg_admin role. I run the following: CREATE EXTENSION pg_cron; After that I go to schedule a job: SELECT cron.schedule_in_database('part_maint_TEST','0 * * *…
How to migrate database users from Azure PostgreSQL single server to flexible server?
Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…
Resetting pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server
How do I reset the pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server? Postgres has a pg_stat_statements_reset() function which can be used but I am not able to execute this function using the server admin account. select…
How to search across multiple vector indexes in PostgreSQL with PGVector
TLDR: Is there a way to query both embedding columns in the same query, and ensure it uses the respective indexes e.g IVFFLAT and HNSW respectively in the same query? I've created this table with pgvector extension enabled: CREATE TABLE IF NOT EXISTS…
Cannot create an "Azure Database for PostgreSQL"
I have been struggling for multiple days with creating a PostgreSQL DB in Azure. I am trying to create it in Germany West. The Service always seems to get stuck at "Get PostgreSQL server List" until it times out about 3h into the deployment…
Azure PostgreSQL Flexible server Time Zone need to change
Azure PostgreSQL Flexible server Time Zone need to change from default UTC to IST, hence need assistance to change the same.
Flexible server performance
I m using Azure PostgreSQL Flexible Server (version 14.x) for a web application with high-concurrency, OLTP workloads. The database is hosted on a Standard_B1ms SKU (2 vCores, 8 GB RAM) and is growing to around 200 GB. We’re experiencing slow query…
ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms
I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…
Internal Server Error while creating DBforPostgreSQL flexibleServers
I keep getting a an unexpected error occured while processing the request to create a new flexible server. Code: InternalServerError
Performance issues after scaling up Azure Database for PostgreSQL - Flexible Server
We're running Azure Database for PostgreSQL - Flexible Server on General Purpose, D8ds_v5 (8 vCores, 32 GiB RAM) with 2Tb storage. After switching to D16ds_v5 (16 vCores, 64 GiB RAM) with 4Tb storage, the performance decreased significantly. All the…
Azure postgres flexible server timescale pgai "ai" extension availability
Hello Does anybody know if there will be a update to timescaledb on azure to make pgai available from timescale? Kind regards Adrian
ADF - postgres: Read method cannot be called when another read operation is pending
I'm using Azure Data Factory copy data activity to move data from Azure PostgreSQL to OneLake. I'm using a self-hosted integration runtime for that (because of how our VNETs are set up). Here is the error I'm getting: Operation on target…
Azure Postgre SQL
Hi Team, Getting connection timed out error while connecting to Azure Postgre SQL server using Data Studio. Can someone please help? Regards, Tahseen
Impact of azure_pg_admin Role on Query Performance in Azure PostgreSQL Flexible Server
We’re using Azure PostgreSQL Flexible Server (v.13) and noticed a significant performance disparity between users that have the azure_pg_admin role and those that don’t. For example, queries that complete in milliseconds for users with azure_pg_admin…
How to fix a malformed backend type returned from an Azure sys query?
A malformed backend_type is returned from an azure_sys query in Azure Flexible PostgreSQL pg_stat_activity table: [ { "state": "idle", "query": "SELECT query_stats.pgms_stats_insert_data", …
Can I change to owner of a database in Azure Database for PostgreSQL flexible server?
I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…
How to fix FATAL: remaining connection slots are reserved for roles with privileges of the "pg_use_reserved_connections" role on an Azure Database for PostgreSQL flexible server.
Hi. I have a database running on an Azure Database for PostgreSQL flexible server. I have been managing the database using pgAdmin. Now i am not able to access or login as i am getting the following error, FATAL: remaining connection slots are reserved…