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
0
votes
1 answer

Unable to create azure postgresql flexible server with azure-cli

I'm trying to create a postgresql database on azure with azure-cli. I set my default location with az configure --defaults location=WestEurope, then I created a resourcegroup, a vnet and a subnet. Now I want to create a flexible server for…
J.M. Kenny
  • 384
  • 4
  • 11
0
votes
0 answers

Azure PostgreSQL flexible server is at 100% cpu utilization

I have an Azure PostgreSQL (version 12) flexible server that has been running at 100% CPU utilization for the last 4 days and the server is currently using 70% of the storage. The Compute core is Standard B1ms (1 vCPU and 2GB Memory) I have checked…
user782400
  • 1,617
  • 7
  • 30
  • 51
0
votes
1 answer

How to solve error -2147467259 when querying large amounts of data in AZURE ML

I am trying to fetch a decent amount of data in Azure ML from a postgresql DB. When I limit the amount of data returned (e.g. LIMIT 100 000) the query executes as expected. However when I remove this limit (and fetch the complete 2 000 000 rows),…
Tibo Geysen
  • 177
  • 2
  • 11
0
votes
1 answer

Azure Database for PostgreSQL server backup before destroy

I currently have an Azure PostgreSQL server which I would like to permanently delete. For obvious reasons I would like to make a snapshot/soft delete before turning off and deleting. What is the simplest way to accomplish this? I know there is a…
Michele
  • 148
  • 1
  • 2
  • 11
0
votes
3 answers

is it possible to execute dblink_connect('dbname=db_name user=postgres') on Azure Postgres DB

I had a Postgresql DB on a Virtual Machine and I have used below line of code is several functions. PERFORM dblink_connect('dbname=db_name user=postgres') Now I am migrating to Azure Postgresql, After several days of process, I have moved the entire…
VIRIYALA NARESH
  • 187
  • 1
  • 4
  • 17
0
votes
1 answer

Azure Postgres Private endpoint not working with dns name

I have disabled the public connection for my azure postgresql database and created the private endpoint connection, I pointed my relevant vnet and subnet while private endpoint creation. Private endpoint connection configuration for successful and…
Debugger
  • 690
  • 1
  • 18
  • 41
0
votes
1 answer

Get response from EXECUTE in PLPGSQL

I have set up a small query that uses a DO block to dynamically edit multiple tables. DO $$ DECLARE _table varchar[]; loop_item text; BEGIN SELECT array_agg(table_name::TEXT) FROM information_schema.tables INTO _table WHERE…
riderinred
  • 53
  • 1
  • 6
0
votes
1 answer

How to Automate Deployment of Azure Database for PostgreSQL using Azure DevOps

Can someone pls help me to automate build and release pipelines in Azure DevOps for Azure DB for PostgreSQL database (Single Server) so that I can create a Database and run different scripts in that database for creating/altering tables, functions,…
S2S2
  • 8,322
  • 5
  • 37
  • 65
0
votes
0 answers

Autovacuum on toast tables in azure PostgreSQL service

We deleted the old data around 300GB from a table.i can see the auto vacuum performing on base table but not on toast table.due to this db size is growing rapidly. I am using the Azure PostgreSQL service. In the base/parent table dead tuples are…
remo
  • 3
  • 2
0
votes
1 answer

unable to connect to Azure Postgres from Azure aks

postgres@name-prod-psql-197fb74f68-9psrh:/$ psql "host=name-prod.postgres.database.azure.com port=5432 dbname=prod user=user password=XXX" psql: error: could not connect to server: Connection timed out Is the server running on host…
DmitrySemenov
  • 9,204
  • 15
  • 76
  • 121
0
votes
2 answers

Optimize Postgress DB having nearly 150 mil records

I'm using Azure Postgress DB to store around 150 mil records. Specs of the DB are: 160GB storage and around 4GB RAM. The Dataset is around 80GB when loaded into the DB. The data set will not going to grow but will remain around 80 - 85 GB. Here's…
KTB
  • 1,499
  • 6
  • 27
  • 43
0
votes
1 answer

Couldn't find network parameters file and compatibility zone wasn't configured/isn't reachable, corda

Am stuck, trying to integrate azure postgres with corda. I'm using gradle's deployNodes task to create the network locally. Below is the exception that I get. [ERROR] 2021-09-06T06:53:02,290Z [main] internal.NodeStartupLogging. - Exception during…
user16528894
  • 19
  • 5
0
votes
1 answer

Azure Server for PostgreSQL failing when migrating with pg_dump and psql

I'm following this tutorial: https://learn.microsoft.com/en-us/azure/postgresql/howto-migrate-using-export-and-import I've successfully created a script file using pg_dump. I ran this on my command line: pg_dump –-host=local --username=postgres…
jack.py
  • 362
  • 8
  • 23
0
votes
1 answer

Is it possible to have a read/write replicas of azure postgresql

Azure have brought out azure flexible postgres which allows read replicas to a different az but we need a read/write solution. Does anybody know of any way to set up read/write replicas in postgres even with a 3rd party solution? Thanks Brian
b Od
  • 39
  • 2
  • 9
0
votes
1 answer

Unable to obtain the connection string for an Azure Postgres database server using the CLI

I have an Azure database server which I need to obtain the connection string for by way of command line. However, it is telling me that the "az postgres server show-connection-string" is not right, that "show-connection-string" is not recognized. …
Richard Wolford
  • 353
  • 2
  • 15
1 2 3
…
11 12