Questions tagged [azure-postgres-database]

Azure Database for PostgreSQL is a relational database-as-a-service from Microsoft running open-source PostgreSQL on the backend.

Filter by
Sorted by
Tagged with
3 votes
1 answer
323 views

Azure postgresql really slow compared to VM

I work with postgresql (and Postgis) for years now on a VM with dockers, and I start to be used to tweak servers parameters and optimize request, and I never had the kind of problems I have with Azure ...
user avatar
0 votes
0 answers
23 views

script to find info on Azure sql dbs,Azure mysql dbs

I would like to check if we have a powershell script which can fetch all properties of a particular service like logical servername, resourcegroup etc for all azure sql databases (PAAS) and azure ...
user avatar
  • 73
0 votes
1 answer
256 views

psql (PostgreSQL client) tool install on RHEL

I would like to install just the PostgreSQL client tool (psql) on RHEL on a container to connect to an Azure database for PostgreSQL server. Can you please point me step by step instructions on how to ...
user avatar
  • 73
0 votes
0 answers
17 views

Equivalent of @@SERVERNAME In Azure PostgreSQL [duplicate]

Is there query to find server / host name from Azure PostgreSQL which is equivalent to @@SERVERNAME in sql server.
user avatar
  • 316
0 votes
0 answers
10 views

Connect to postgres11 using psql in a container

I'm looking for a way to connect to postgresql11 (azure PAAS instance) using psql tools installed on docker container. I would like to psql container installed on the same node where we have an ...
user avatar
  • 73
0 votes
1 answer
167 views

Azure PostgreSQL archiver exited with exit code 1

I'm using Azure PostgreSQL server to store data in my application hosted on Azure App Service. Yesterday, at some point application started to throw exceptions with connection closed and broken pipes. ...
user avatar
  • 103
0 votes
0 answers
69 views

pg_restore idling during second half of restore

We're migrating from PostgreSQL hosted on our VM to Azure Database for PostgreSQL managed database. One of the first problems we hit has been time to restore database dump. It took 20-30 min on our VM ...
user avatar
  • 1
-1 votes
2 answers
178 views

What are the SSL options to connect my new users to my PostgreSQL database

I want to create a new user in my database PostreSQL database hosted on Azure. So, following the documentation from Microsoft for pgAdmin, I went to PGAdmin and ran the following command: CREATE ...
user avatar
0 votes
2 answers
425 views

How to automate the detection of the column type of a csv file for a table creation script?

I am new to pgAdmin and Azure database. I have a huge csv file with around 220 columns and I want to create a table out of it in pgAdmin4 to push it to Azure. However I don't know how to detect ...
user avatar