Stack Overflow
Stack Overflow

Questions tagged [azure-postgresql]

Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.

Links:

  1. Azure Database for PostgreSQL - Official site
  2. Azure Database for PostgreSQL - Documentation
171 questions
2
votes
2 answers

How to connect to Azure Database for PostgreSQL flexible server from azure data studio

I'm using Azure Database for PostgreSQL flexible server in my azure account. I'm not able to connect to this server from azure data studio, getting the below error...I have already installed the Postgres extension in the azure studio. Thanks in…
Chaitali
  • 87
  • 13
2
votes
1 answer

How to do bidirectional data sync b/w Azure postgresql & onPrem oracle DB

I have an Oracle DB with data in onPrem and Azure Postgresql DB in cloud. I really need data changes in Oracle to be reflected as near to real-time as possible in Azure Postgresql DB. I need data changes in Azure Postgresql DB to be reflected as…
ga7202
  • 93
  • 8
2
votes
1 answer

Migration Postgresql table to timescale db

i have that table CREATE TABLE mytable ( device_id bigint NOT NULL, start TIMESTAMP WITHOUT TIME ZONE, level varchar(255) NOT NULL, amount integer ); and i want to migrate it to a hypertable like that: SELECT…
IEE1394
  • 1,181
  • 13
  • 33
2
votes
0 answers

Grant AKS access to Postgres database in Azure via VNet

Trying to figure out how to best give my AKS cluster access to a Postgres database in Azure. This is how I create the cluster: az group create \ --name $RESOURCE_GROUP \ --location $LOCATION az aks create \ --resource-group $RESOURCE_GROUP \ …
Joel
  • 8,502
  • 11
  • 66
  • 115
2
votes
1 answer

Reset Azure PostgreSQL Server User Password through CLI

How to change/reset the password for the User in Azure Postgresql Server through CLI. I know there's a way how to reset password through Portal but am looking for resetting through Azure CLI . I tried ALTER USER {user} WITH PASSWORD '{password}';…
Prateek Chaudhary
  • 141
  • 10
2
votes
1 answer

Azure Postgres SSL allow to login without Certificate

I am trying to connect Azure Postgres instance with SSL enabled. My understanding is if SSL enabled, I must provide certificate for authentication but it allow me to connect without passing any certificate. I am using below command:- psql…
JAVED ANSARI
  • 21
  • 1
2
votes
1 answer

org.postgresql.util.PSQLException: SSL error: Received fatal alert: handshake_failure while writing from Azure Databricks to Azure Postgres Citus

I am trying to write pyspark dataframe to Azure Postgres Citus (Hyperscale). I am using latest Postgres JDBC Driver and I tried writing on Databricks Runtime…
anshul_cached
  • 684
  • 5
  • 18
2
votes
1 answer

No VNET option for Azure PostgreSQL Server

I am trying to add my PostgreSQL server to an existing VNET, however, I can't find the option to do so. I was able to add my app service and even found this tutorial for PostgreSQL, but the UI under "Connection Security" does not give me the…
user2253546
  • 575
  • 1
  • 8
  • 18
2
votes
2 answers

TimescaleDB in Container

I need help to write Dockerfile to create TimescaleDB in a container. I found this instruction for creating a container: docker run -d --name timescaledb -p 5432:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb:latest-pg12 But I want to be…
Vitalii Fedorenko
  • 279
  • 6
  • 18
2
votes
2 answers

Azure Data factory Copy Pipeline failing if more than 6 columns

I'm trying to copy data from a view in either on-premise PostgeSQL or MSSQL to a table in Azure PostgreSQL. I can't seem to get this to successfully copy when I map more than 6 columns from source to sink. I suspected that one of the source columns…
Matt
  • 53
  • 1
  • 6
2
votes
1 answer

Using uuid_generate_v1() produces UUID with trailing zeros in Azure PostgreSQL

I am not sure what to make of this weird behavior with generating UUID values. I know uuid_generate_v1() is not as secure as uuid_generate_v4(). We are executing uuid_generate_v1() inside a function to generate a unique Id. Initially when the…
Ed Mendez
  • 1,510
  • 10
  • 14
2
votes
1 answer

Is there a way to override the server configuration 'statement_timeout' on Azure DB for PostgreSQL?

In the Azure Portal under PostgreSQL the server configuration statement_timeout controls the following. "Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off." There doesn't seem to be a way to override that…
Ed Mendez
  • 1,510
  • 10
  • 14
2
votes
1 answer

invalid input syntax for type timestamp

While running the below code i get an error saying invalid input syntax for type timestamp from admission_datetime. UPDATE ccsm.stg_demographics_baseline SET xx_los_days = (CASE WHEN admission_datetime IS NULL OR …
Sachin
  • 35
  • 1
  • 1
  • 6
1
vote
1 answer

Cannot use siglen parameter while creating index gist_trgm_ops in PostgreSQL 11.19 (Azure flexible DB)

When trying to create index on remote Azure server (PostgreSQL 11.19 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit) create index test on "Table" using gist("Name" gist_trgm_ops(siglen=256)); with custom siglen…
Anton Chaika
  • 21
  • 3
1
vote
0 answers

Azure PostgreSQL Flexible Server database migration for Jira

I am trying to migrate my Jira database which I am running on my Azure PostgreSQL single server to the new flexible server. When doing the migration I am encountering the following error: pgcopydb failed with the errors: 2023-06-23 08:07:11 32…
apasic
  • 58
  • 6
1
2
3
…
11 12