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.
9
questions
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 ...
- 131
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 ...
- 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 ...
- 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.
- 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 ...
- 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.
...
- 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 ...
- 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 ...
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 ...