1,188 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

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…

Azure Database for PostgreSQL
asked 2025-01-13T16:57:23.53+00:00
Grover, Jyoti 40 Reputation points
commented 2025-01-14T23:21:02.52+00:00
Oury Ba-MSFT 20,186 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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 Database for PostgreSQL
asked 2025-01-13T03:08:17.9666667+00:00
Jeferson Galhardi de Godoy 20 Reputation points
accepted 2025-01-13T03:49:27.7066667+00:00
Jeferson Galhardi de Godoy 20 Reputation points
2 answers

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…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,749 questions
Azure Database for PostgreSQL
asked 2024-08-23T08:53:50.2166667+00:00
Vipal Mehta 40 Reputation points
commented 2025-01-10T17:14:52.0333333+00:00
Oury Ba-MSFT 20,186 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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 * * *…

Azure Database for PostgreSQL
asked 2024-11-20T22:35:13.98+00:00
Herman, Justin 35 Reputation points
commented 2025-01-10T14:22:18.88+00:00
Eric Swiggum 0 Reputation points
0 answers

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,…

Azure Database for PostgreSQL
asked 2024-10-16T19:27:38.1866667+00:00
David Carson 0 Reputation points
commented 2025-01-08T20:48:18.1333333+00:00
Matthew Mckenzie 5 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure SQL Database
Azure Database for PostgreSQL
asked 2024-08-25T05:18:06.2366667+00:00
tugce tay 20 Reputation points
accepted 2025-01-07T17:09:13.1633333+00:00
tugce tay 20 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,991 questions
Azure Database for PostgreSQL
asked 2025-01-06T13:46:39+00:00
Vision Intelligence 60 Reputation points
accepted 2025-01-07T16:49:13.7333333+00:00
Vision Intelligence 60 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 2025-01-07T13:57:32.81+00:00
József Orbán 30 Reputation points
commented 2025-01-07T15:49:19.3533333+00:00
Vijayalaxmi Kattimani 1,085 Reputation points Microsoft Vendor
1 answer

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…

Azure Database for PostgreSQL
asked 2024-12-30T09:58:35.8366667+00:00
Maira Tariq 0 Reputation points
edited an answer 2025-01-07T06:05:28.9066667+00:00
ShaktiSingh-MSFT 16,236 Reputation points
0 answers

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 Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,254 questions
Azure Database for PostgreSQL
asked 2024-12-31T11:49:47.77+00:00
Shah, Apoorv-XT 0 Reputation points
commented 2025-01-07T04:26:50.18+00:00
Sai Krishna Katakam 1,710 Reputation points Microsoft Vendor
1 answer

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 Database for PostgreSQL
asked 2024-12-31T03:22:37.6833333+00:00
Cuong Tran 0 Reputation points
commented 2025-01-03T02:35:23.2+00:00
Vijayalaxmi Kattimani 1,085 Reputation points Microsoft Vendor
1 answer

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…

Azure Database for PostgreSQL
asked 2024-12-31T10:53:33.0433333+00:00
PGT 0 Reputation points
commented 2025-01-03T02:10:12.98+00:00
Sai Raghunadh M 2,315 Reputation points Microsoft Vendor
1 answer

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 Database for PostgreSQL
asked 2024-12-18T06:19:36.7233333+00:00
Kode Sasikiran 0 Reputation points
commented 2025-01-02T09:35:53.9733333+00:00
Kode Sasikiran 0 Reputation points
2 answers

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…

Azure Database for PostgreSQL
asked 2024-12-23T14:24:57.3633333+00:00
MR Subbato 0 Reputation points
commented 2024-12-31T09:43:41.9433333+00:00
NIKHILA NETHIKUNTA 4,510 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

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 Database Migration service
Azure Database for PostgreSQL
asked 2024-12-31T03:15:31.8233333+00:00
njnjkkl 20 Reputation points
answered 2024-12-31T05:20:50.7633333+00:00
Vijayalaxmi Kattimani 1,085 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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
asked 2024-12-03T12:18:18.07+00:00
Fabien Donnet 20 Reputation points
accepted 2024-12-26T16:42:22.6433333+00:00
Fabien Donnet 20 Reputation points
1 answer

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 Database for PostgreSQL
asked 2024-12-19T12:47:56.74+00:00
Benjamin Krüger 0 Reputation points
commented 2024-12-23T13:59:30.69+00:00
Sai Raghunadh M 2,315 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

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

Azure Database for PostgreSQL
asked 2024-11-16T20:15:26.7166667+00:00
Adrian Ruchti 20 Reputation points
edited the question 2024-12-23T13:32:34.92+00:00
navba-MSFT 27,465 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2024-12-18T14:21:24.9466667+00:00
Petro Kostiuk (EXT) 20 Reputation points
accepted 2024-12-18T19:26:02.5833333+00:00
Petro Kostiuk (EXT) 20 Reputation points
1 answer

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#

Azure Database for PostgreSQL
asked 2024-12-07T06:57:38.4266667+00:00
Clark Leovison Rey 0 Reputation points
commented 2024-12-18T15:42:45.07+00:00
NIKHILA NETHIKUNTA 4,510 Reputation points Microsoft Vendor