convert postgresql to spark sql
Has any one has used or is aware of a tool that can convert postgresql code to Spark SQL code to run in Databricks? our case: we have to write query in dbeaver to create new logics but want to create new views/tables using Data bricks. We have…

Create Postgres error Subscription 'xxxxxx' is not allowed to provision in 'East US'.
I am trying to create a postgres database in the East US region, but I get the following error Subscription 'xxx' is not allowed to provision in 'East US' Please, does anyone know how to solve it?
Azure Cosmos Postgresql issue with Role creation
Hi, We are using Azure Cosmos Postgresql DB and we are experiencing issues with Role creation. We created a role from console as well as az cli using below command - The command shows succeeded and the role is visible. However the same role is not…

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 * * *…
Postgres Flexible Server 15.8 No Longer Supports ANY md5 Functionality
The 15.8 version of the server no longer supports md5 hashing. The 15.7 version allows us to call the MD5() function within the server. We DO NOT use this function for passwords or other security mechanisms. It is purely used to create a unique,…
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
Can't renew reservation for Azure Database for PostgreSQL expiring
Presently still using Azure Database for PostgreSQL - Single Server. We have a reservation that expires near end of January (azuredb_postgresql_general_purpose_compute_gen5 - East US). When attempt to purchase another reservation, only Flexible Server…
How to fix 'Service and subscription limits' on PostgreSQL Fexible Server deployment using bicep file?
tags: ResourceDeploymentFailure, PostgreSQL Fexible Server deployment, bicep file, MS Learn tutorial, Git cloned .../mslearn-postgresql.git Exceptions support request with Issue type of 'Service and subscription limits'. I cannot file Exception Support…

ERROR: permission denied for schema cron
Hi, I am running Azure PostgreSQL Flexible Server with PostgreSQL version 15.7. I am trying to enable pg_cron in my server on my custom database (not postgres), but I am getting the permission error: ERROR: permission denied for schema cron. I have…
Connection Refused from AKS cluster to Postgres Flex server
Hi All, I am getting connection refused error while connecting to Postgres Flex server from AKS Cluster pod. Same Postgres Flex server connection is working fine from PgAdmin. Can someone please help what could be wrong configuration from AKS…
Azure database for Postgres Flexible server - Why creating extension requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server Currently, I have faced the issue when creating an extension, it said that the user should be a member of azure_pg_admin. However, this was not the case a couple of months back as…
Azure Cosmos for PostgresDB provisioning error when specifying authConfig
I'm seeing an issue when trying to provision a Cosmos for PostgresDB instance using terraform/arm templates. I can provision this configuration successfully, but if I uncomment the 'authConfig' block it fails with a "500 - Internal Server…
How to migrate Postgres Database from One Azure Entity to Another Azure Entity
Hi, We have a PostgreSQL flexible server hosted on Azure under the entity (abc.com). Due to some business changes, we need to migrate the PostgreSQL database from entity (abc.com) to entity (xyz.com). Could you please suggest the best ways to perform…
Azure postgresql server getting stuck
My Azure PostgreSQL managed database server is stuck. I tried connecting to it, but it didn't work. When I attempted to restart the server, I received the error: "The server is currently in 'restarting' state. Please wait for the operation to…
Unknown error occurred on migrate azure postgres single server to azure postgre flexible server
I follow the online migration set up to migrate the single server from version 10.0 to flexble server version 11.0.But after passing the the validation the migration was failed.This is the error log. pgcopydb failed with unknown errors. Please contact…
Azure Cannot delete postgres flexible server
Hello, I cannot delete my resource: Unkown error in Azure and "is busy with another operation" with the az cli.... How I can debug. I can start/stop the resource but I m not able to remove it.
Azure Database for PostgreSQL Metric Storage Percent remains empty
Hi Community, i have a Azure Database for PostgreSQL flexible Server and want to monitor the Metric "Storage Percent". When I configure the According Graph, it remains empty: As far as I found out through googling, this Metric should be Active…
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
In PostgresSQL dont work parammetr "Allow public access from any Azure service within Azure to this server" on china region
Hi, I am using Azure Database for PostgreSQL in the China region. I also use Azure DevOps for my CI/CD processes. Currently, I am facing an issue where I cannot perform database migrations or execute scripts for the database through Azure Pipelines (in…
PostgresException: 42P01: relation "waitdb" does not exist
Hi, I was having a trouble about 42P01:relation when using postgres sql, Here's the code that i've been using and for my tables here's the table. For my configuration, is there something wrong with it? Thank you for response, since i am new to c#