Stack Overflow
Stack Overflow

Questions tagged [azure-database-postgresql]

"Azure Database for PostgreSQL" is PostgreSQL as-a-service in MS Azure. Use this tag specifically for the azure service "Azure Database for PostgreSQL". DON'T use it for PostgreSQL hosted on a Azure virtual machine.

38 questions
1
vote
1 answer

Azure_superuser account password for Postgresql database on Azure

I have provisioned Azure Database for Postgresql, I'm trying to execute copy command in c# Azure function to load data from csv file to the database. It throws an error saying ERROR: must be superuser to COPY to or from a file The question is how do…
user2350134
  • 11
  • 1
  • 4
1
vote
1 answer

How can I use a Azure Database for PostgreSQL in a Azure Logic App?

To simulate a device I want to use a Logic App to fill a Azure Database for PostgreSQL with test data. I found the two connectors PostgreSQL and SQL server but unfortunately both don't work for me. The PostgreSQL connector does only support…
CrazySocke
  • 13
  • 5
1
vote
1 answer

How to create database template on azure postgresql service

While using the database service for postgresql om azure, it looks like it is not possible to create a custom template database. What I want to achieve, is that a regular account, csn create new databases with a specific extension enabled. The…
Wouter
  • 371
  • 2
  • 12
1
vote
4 answers

API for Azure Database for MySQL

Azure Database for MySQL server is still in preview, though we can created database instance on it. I wonder do we have any API to retrieve the databases that we created on Azure Database for MySQL server? API for metrics of those databases? Same…
Jerry
  • 21
  • 2
0
votes
0 answers

Copy production DB from one Azure Database for PostgreSQL Single Server to another one in a lower environment

I was working on a project in which customer is asking us to copy a production DB (87 GB) from a production Azure Database for PostgreSQL Single Server (version 11) to another one in pre-production with same version and both are in same Azure…
Ivan IP
  • 1
  • 1
0
votes
2 answers

Connecting to an Azure Database for PostgreSQL flexible server from an Azure Function serverless

I have an Azure Function that connects to an Azure Database for PostgreSQL flexible server, but I am getting a timeout (while from my local I can do it without any problem). After some research, I found out that the pricing tier of the Function…
Rorepio
  • 332
  • 1
  • 4
  • 16
0
votes
1 answer

PGBouncer-Azure Database for PostgreSQL Flexible Server

I created a new database in Flexible Server and enabled the pgbouncer. When I run SHOW DATABASE, it only displays two databases. How to assign a newly created database to pgbouncer.please find the screenshot
remo
  • 3
  • 2
0
votes
0 answers

I am using Azure PAAS service of Postgresql Flexible Server

I have installed the packages postgresql12-odbc (not just postgresql-odbc) and unixODBC and client tool as well while connection from my applicatio server I got psql: /usr/pgsql-12/lib/libpq.so.5: no version information available (required by psql)…
Rabia
  • 1
0
votes
1 answer

Azure Microsoft.DBforPostgreSQL flexibleServers database collations

I tried to create new database with different (than en_US.utf8) collation on Azure Microsoft.DBforPostgreSQL flexibleServers. CLI and Bicep gives "Internal Server Error" as a message and from Portal I cannot change the collation select input at…
Räyhä
  • 41
  • 2
0
votes
1 answer

Azure Database for PostgreSQL flexible server logs not working

I am trying to run logs for Azure Database for PostgreSQL flexible server, but I keep on getting this in the image below, what could be the solution?
Lutaaya Huzaifah Idris
  • 3,596
  • 8
  • 38
  • 77
0
votes
1 answer

Azure PostgreSql ODBC connection error SSL SYSCALL error: Connection reset by peer (0x00002746/10054)

I am trying to create a odbc connection for a Azure PostgreSQL db. Currently getting the error SSL SYSCALL error: Connection reset by peer (0x00002746/10054). When I disable Enforce SSL Connection, on the Azure PostgreSQL the connection is…
aruN
  • 161
  • 1
  • 6
0
votes
1 answer

How can you incorporate/sync specific table details from Azure database for Postgres into SQL Server?

It is for an asp.net core project following microservice architecture.
Sreelakshmi S
  • 1
  • 2
0
votes
1 answer

Safely drop a user in Postgres

I am very new to Postgress security topic. I have used the following commands to create a user. CREATE USER myuser WITH PASSWORD 'PASSWORD'; GRANT CONNECT ON DATABASE "MyDB" TO myuser; GRANT ALL PRIVILEGES ON DATABASE "MyDB" TO myuser; GRANT ALL…
Mori
  • 2,484
  • 5
  • 28
  • 45
0
votes
1 answer

Connect to Azure Database for PostgreSQL server with Prisma

I am looking for a way to connect my Next.js application with Azure Database for PostgreSQL server. Prisma seems to work well with Next.js but I can't figure connection string or if it is even supported database. Example: DATABASE_URL =…
Tomáš Tom Haverla
  • 187
  • 3
  • 16
0
votes
1 answer

Azure database for postgreSQL Flexible Server and Entity Framework Core shows accented spanish words incorrectly

I have created a Flexible Server (Azure database for postgreSQL), I am using pgadmin to connect to this database (Encoding UTF8), I have a table named skills, and using pgadmin shows the spanish words correctly. SHOW SERVER_ENCODING; UTF8 SHOW…
EduardoUstarez
  • 603
  • 11
  • 22
1
2
3