Azure Database for PostgreSQL is a relational database-as-a-service from Microsoft running open-source PostgreSQL on the backend.
Questions tagged [azure-postgres-database]
13 questions
5
votes
2 answers
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 Postgresql.
The problem is the following:…
robin loche
- 150
- 1
- 4
3
votes
0 answers
Why is the admin user becoming a member of newly created role in Postgres?
I am quite new to PostgreSQL. We have a database server on Azure Postgres Flexible Server. I log in to that server using the admin credentials, dmsadmin. Then I create a new role using the command, CREATE ROLE dev_user1. Now running the \du, gives…
Amit Kumar
- 131
- 3
3
votes
2 answers
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 do the same?. I do not want to install the…
kevin
- 133
- 1
- 3
- 10
1
vote
1 answer
Azure Postgres Unable to create database - errors with must be able to SET_ROLE
We've set up a Azure Postgres database and are trying to run our database/schema/tables creations scripts. These script have worked fine on our VM/server based database hosts where we connect to the database as:
sudo -u postgres psql
But for AZ…
Pro West
- 143
- 1
- 6
1
vote
1 answer
Why is DISCARD ALL called many times in Azure PostgreSQL?
I am debugging a high CPU load issue with Azure PostgreSQL flexible server. In the time window where CPU usage spikes I am seeing a lot of utility queries. They don't take long to process but there are hundred thousands of them.
The queries are all…
DarkLeafyGreen
- 113
- 5
1
vote
0 answers
What is Azure doing to cause PostgreSQL Flexible Server to throw error 08P01?
I'm running a Ruby on Rails application against Postgres servers. For a long time, I've struggled with the background delayed_job process falling over at seemingly random times, and needing to be restarted. The error messages in the delayed_job…
David Krider
- 77
- 3
- 8
1
vote
0 answers
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 but on hosted solution it takes more than 4…
mario
- 11
- 2
1
vote
2 answers
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 automatically the types of columns.
Here is an exemple…
Revolucion for Monica
- 677
- 2
- 11
- 27
0
votes
1 answer
Optimizing TimescaleDB Setup for High-Volume Time-Series Data
I'm seeking advice on how to optimize my TimescaleDB setup, which handles a large volume of time-series data. I have around 20,000 time-series profiles with a one-year duration, using a quarterly time resolution (4 timestamps per hour). This amounts…
Hannes
- 1
0
votes
0 answers
Permission Denied on Select tables after giving Select permission to new user in Azure Postgres SQL single server database
I have Azure postgresql single server database which I need to give read permission to a newly created user.
CREATE USER "test@hostName" PASSWORD 'XXXX';
GRANT CONNECT ON DATABASE "test" TO "test@hostName";
ALTER DEFAULT PRIVILEGES
FOR USER…
SOUser
- 31
- 6
0
votes
1 answer
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.
At first glance it looked like a problem with…
ashur
- 103
- 2
-1
votes
2 answers
Postgres simple SQL select query sometimes latency jump to 900ms
I have an "insert only" table that store user information
id bigint -> Primary key, not null
user_id bigint -> foreign key, not null
first_name character varying null
middle_name character varying null
last_name character varying not null
email…
Rickless
- 101
- 5
-1
votes
2 answers
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 ROLE rikkiWITH LOGIN NOSUPERUSER INHERIT CREATEDB…
Revolucion for Monica
- 677
- 2
- 11
- 27