Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.
1,993 questions
2 votes
0 answers
70 views
OnlyOffice + postgresql : FATAL: password authentication failed for user "onlyoffice"
I've just tried to install the docker version of onlyOffice an my Mageia9 server. The postgresql database seems correct : /var/lib/pgsql # psql -h localhost -U onlyoffice -d onlyoffice Password for ...
- 21
0 votes
0 answers
71 views
Postgresql keeps binding on port different than 5432
I have a problem similar to https://dba.stackexchange.com/questions/185622/how-do-i-change-postgresql-to-be-listening-on-port-5432 , though not necessarily exactly the same. If port is defined as 5432 ...
- 1,633
0 votes
1 answer
146 views
Ubuntu 24.4 Postgresql remote access
I am trying to get basic setup working for remote access to postgresql server. I have postgresql.conf: listen_addresses = '*' and pg_hba.conf: host all all 0.0.0.0/0 ...
- 11
0 votes
0 answers
46 views
After Ubuntu upgrade, PG connection to server on socket failed
After upgrading a Rails app server from Ubuntu 22.04.5 to 24.04.2, my Rails app will not start, nor can I run rails db:migrate. I see this error: ActiveRecord::DatabaseConnectionError: There is an ...
0 votes
1 answer
418 views
Installing Postgresql 16 on CentOS 7 [closed]
I followed the instructions here to install the custom Yum repo. It looked like it installed correctly. But then yum install can't find the postgresql16-server package. I ran sudo yum repolist, and I ...
- 135
0 votes
0 answers
41 views
GCP postgres database is showing 3 TB storage consumption, whereas replicas are sitting at 120 GB only
my org is using gcp's postgres server as our production db. past few months, we've been busy with projects not related to db specifically, so no one was monitoring anything. (screenshot below) (first ...
google-cloud-platform
1 vote
1 answer
257 views
How to set up SSO for PostgreSQL 16 on RHEL 9, without creating new database users?
I need to set up Single Sign-On (SSO) for a PostgreSQL 16 database running on a RHEL 9 Linux server. My goal is to provide passwordless access to users who are part of a particular domain (for ex: ...
- 161
0 votes
0 answers
39 views
Opening ports for Postgresql on Oracle OCI "Always free" Linux 7.9 machine
I've updated the VM's firewall-cmd stuff and it shows VM Firewall-cmd --list-all I've opened the vcn ingress rules, Ingress Rules I'm trying to connect with pgAdmin4, but NO.... pgAdmin And being a ...
0 votes
2 answers
112 views
How should a database be restored from pg_dump to a cluster?
I've dumped a database from a single standard postgres database (official docker image). It was originally migrated from sqlite, but I couldn't use pgloader with the target cluster of 4 replicating ...
- 123
0 votes
0 answers
94 views
pgpool II does not cleanup idle connection
We are running pgpool II with three PostgreSQL DBs - one main and two replicas. The env is running in k8s deployed with bitnami postgresql-ha helm chart. The pgpool II configuration is as follows: We ...
- 101
0 votes
0 answers
156 views
Connections with SD state between HAproxy and Postgres
I’m experiencing an issue with the connection between my PostgreSQL database (a cluster managed by Patroni) and HAProxy. Everything in the application that uses the database works fine, and I don't ...
- 1
0 votes
0 answers
111 views
Low performance in VPS vs Local machine with Docker
I have developed a web application using Laravel and PostgreSQL as the database. The main function of my application is to process large volumes of data from the database, with tables ranging from a ...
- 1
1 vote
1 answer
173 views
How can I grant all privileges on a database in PostgreSQL
We have a template database with schemas, tables, sequences etc. We create a new database from it and provide ownership of the new database to a user (a new user created as part of this workflow). The ...
- 160
0 votes
0 answers
75 views
Very slow new field to postgresql table
We have a postgresql table database with a table which has 150M+ records inside. Also this table is pretty much a core table where almost everything is referenced to. So here is the deal; we need to ...
0 votes
1 answer
78 views
PostgreSQL on Windows - nagios monitoring
Recently I have migrated old Veeam to a new Virtual machine. The new Virtual Machine: Windows Server 2022, Veeam 12.3, PostgreSQL 15 which is running on the same VM. Currently I am monitoring some ...
- 3
1 vote
1 answer
436 views
Custom jail for postgresql (fail2ban)
I try to write custom jail for PostgreSQL. My log line looks like this: 2025-01-24 14:43:17.769 CET [112253] postgres@postgres FATAL: no pg_hba.conf entry for host "x.x.x.x", user "...
- 11
3 votes
1 answer
333 views
Do EPEL PostGIS packages remain compatible with Red Hat-supported PostgreSQL for the full RHEL lifecycle?
Background I'm planning to set up a PostgreSQL/PostGIS server on RHEL 9.4 as part of migration work from an older version of RHEL and am comparing upgrade paths from a stability perspective. If I ...
- 133
0 votes
0 answers
17 views
Postgres trying to make socket connection to external IP address [duplicate]
I have a Almalinux server from Hetzner 12 cores CPU and 128 GB RAM and then installed psotgres and everythings went ok. but nowadays postgres drains cpu and memory and the server IP blocked by data ...
- 1
0 votes
0 answers
105 views
PostgreSQL repmgr slow initializing replica
I have two postgresql nodes, pg-0 and pg-1, master and replica. They are running on different machines with a 25bg/s bandwidth, 8gb ram and an AMD Epyc processor. Inside i have 6 dbs totaling 1.5gb, ...
0 votes
0 answers
170 views
Gcloud SQL Postgres 13 inplace upgrade fails for collation 'en_US.UTF-8'
I'm trying to perform and inplace upgrade a Postgres 12 database in Google Cloud to version 13. However, I get the following error: pre-upgrade check failed: [detail:"Please change the '...
0 votes
0 answers
42 views
Share privileges across several postgresql servers
I have several Postgresql servers on a local network, and I need them to have the same users/roles, privileges, etc. To achieve part of this, we can use LDAP to handle the user verification, pg-ldap-...
- 1
0 votes
0 answers
187 views
pgAdmin4 in Kubernetes says Refused to execute script, strict MIME type checking is enabled?
I am trying to run pgAdmin4 in Kubernetes but i always get "Refused to execute script, strict MIME type checking is enabled?" error and other errors. According to strict MIME type checking ...
- 101
0 votes
0 answers
189 views
Pgbouncer to postgresql auth failures
I have deployed the airflow Version: "2.9.3" in kind cluster using Airflow official latest helm chart. I have configured PostgreSQL and Pgbouncer both to use md5 password encryption ...
0 votes
1 answer
204 views
pgpool2 auto_failback doesn't attach node
I seem to be having an issue with auto_failback, pgpool detects that the node is back up but it wont reattach it. I am running postgres 17 and pgpool2 4.5, this is config listen_addresses = '*' port = ...
- 141
0 votes
0 answers
72 views
PostgreSQL Permission Denied After Docker Migration Between VPS Using rclone
[Help] PostgreSQL Permission Denied After Docker Migration Between VPS Using rclone Problem I'm getting permission denied errors while trying to set modification times on PostgreSQL files after ...
6 votes
1 answer
2k views
Is swap memory required when using Postgres on Linux?
So, my friend says swap is an old concept and shouldn't be needed on new systems as long as you have enough RAM. But then I heard suggestions that swap might actually be required when using Postgres ...
- 703
0 votes
0 answers
307 views
psql privilege warnings for schema public
I recently upgraded my local PostgreSQL to v17. Now when I create a database dump using pg_dump -c, importing that dump with psql on the server (running PostgreSQL 16) results in the following ...
- 291
1 vote
1 answer
150 views
Dovecot is not complaining about self-signed certificate while connecting to PostgreSQL over SSL
I enabled SSL on my PostgreSQL database and enforced it using pg_hba.conf with the following line: hostssl all all 0.0.0.0/0 md5 From the PostgreSQL connection logs and network traffic captured via ...
- 121
0 votes
1 answer
937 views
Why is PostgreSQL not prompting for password?
In PostgreSQL, I have the following configuration in pg_hba.conf: local all sec_eng scram-sha-256 host all sec_eng scram-sha-256 hostssl all app_server ...
- 3
1 vote
1 answer
1k views
Coredump file not generating
Suddenly my postgresql service started crashing for some reason. I wanted to generate coredump file but file is not generating. I set: "ulimit -S -c unlimited", also added line "*soft ...
0 votes
1 answer
956 views
Cannot connect to postgres 16 remotely
I think I have exhausted everything I can think of. Using postgresql 16 If I try to connect with psql -d dbname -h localhost it prompts for a password and connects just fine. However, if I try to ...
- 1
2 votes
0 answers
141 views
Not able to compile PG16 with custom flags in freebsd 14.1 - GCC fatal error cannot read spec file
Hi everyone I am trying to install Postgresql 16 on my freebsd 14.1 hosted in an ec2 machine on AWS. I am using GCC13 to compile the binaries and I keep on running into gcc13: fatal error: cannot read ...
- 21
1 vote
0 answers
175 views
How to reduce disk space usage during PostgreSQL upgrade
I want to upgrade a large PostgreSQL database using the following command: docker-compose exec db pg_dumpall -U app | docker-compose exec -T db16 psql -U app I expected the upgrade to require roughly ...
- 848
0 votes
1 answer
412 views
Why is my pg_basebackup incompatible with Postgres?
I have a backup shell script which runs pg_basebackup every night. When I try to run it though I get this error message saying that pg_basebackup is apparently not compatible with Postgres.app version ...
- 1
2 votes
1 answer
881 views
Mysterious spikes in Postgres query latency
At work we've been running into a sort of mysterious problem. Every few hours, one of our tables (tasks) sees query latency grow (caused by CPU use) followed by a burst of LWLock:BufferContent, then ...
- 689
0 votes
2 answers
525 views
Can't launch PostgreSQL Database (Data lost??)
macOS Sonoma 14.2.1 (23C71), just updated to 14.5 (23F79) Story I had a python script (norgis ALKIS-Import) importing a lot of Data into my Postgres Database over the weekend. When I came back today ...
- 1
1 vote
2 answers
4k views
Cannot create database in PostgreSQL
I am a complete beginner on PostgreSQL, and I am following an introduction to databases to set up a local PostgreSQL database and connect to it. I am running Debian 15, so I do the following: # apt ...
0 votes
1 answer
194 views
Can not access PostgreSQL Server on Windows from Linux on VMware Workstation
Windows host with Vmware Workstation, and a linux guest. I have another Windows host with PostgreSQL running on localhost:5432. I established NAT connection to be able to use Internet in VM. Vmnet1 ...
- 3
1 vote
0 answers
56 views
Google Cloud SQL Pricing
For R&D matters i need a small postgresql server. As I am totally naïve to google cloud platform, I don't understand the way google bill an instance. The VCPUs are typically factured on a sub-...
0 votes
1 answer
397 views
How to determine what is causing my node server with nginx to crash at high request rate?
We are developing a SaaS product which is an easy to use invoicing software. We are using React for the frontend app and Node (with fastify web framework and sequelize as ORM) for developing a RESTful ...
-1 votes
2 answers
230 views
How do companies manage software versioning for tools, frameworks, etc.?
If a company is using many different software, is there a way to automate version tracking - comparing current version being used in the company and latest version released, and maybe taking actions ...
- 1
0 votes
1 answer
455 views
Virtual IP setup on two VMs using pacemaker
Do we need 3 VMs to set up pacemaker virtual IP to maintain quorum? I currently have two VMs running Postgres bi-directional replication. I want to create one IP address for communication. How to ...
0 votes
0 answers
337 views
Random CPU + MEMORY spikes issue on Ubuntu server + Docker + PostgreSQL
I've been encountering an issue that has been bothering me for a while now. I have a Google Cloud VM running an Ubuntu 18.04 server with several containers, including a PostgreSQL server, a Redis ...
1 vote
1 answer
4k views
How to pg_dump from old version of postgres?
I'm really scratching my head. I was under the impression that newer versions of pg_dump can export from older versions. However, I keep getting this error: pg_dump: error: aborting because of server ...
- 831
0 votes
2 answers
2k views
How do I configure SE Linux so PHP can connect to Postgres by socket
I have a PHP application that connects to a Postgresql Database. This works when I connect via network but I get an SELinux violation when trying to connect using the socket. I believe the contexts ...
- 105
0 votes
1 answer
133 views
Data migration between postgresql-9 and postgresql-11 [closed]
What is the best way to migrate postgres-9 database with size of hundreds GB to postgres-11 ? I'm afraid that third party tools will take too long to do this.
- 5
2 votes
0 answers
112 views
Bacula Postgresql Huge Logs table
We currently have Bacula Enterprise v12 installed on our production. We seem to have a problem with BWEB regarding the logs of any job. it takes forever for the web interface to load the logs. After ...
- 21
0 votes
0 answers
359 views
Google Cloud SQL [PostgreSQL] Database storage is Increasing
I have a database instance (PostgreSQL v12.6) on Google Cloud and since 10 days ago, the Storage of Database is increasing rapidly. Here's my Observations: list of Dtabases Dashboard of Disk Space ...
0 votes
1 answer
547 views
PostgreSQL Backup: how to activate backup mode non-interactively
Hello PostgreSQL experts! I'm running a postgresql 15 server with multiple database instances ("clusters"), which uses Netapp NFS as storage for the data and WAL directories. I'm trying to ...
- 21
0 votes
2 answers
301 views
Issues with VPS provider limiting CPU usage with data processing Spring Boot application
I developed a Java Spring Boot application with a PostgreSQL database. Since the data being processed is quite a lot, the processing can take time and it uses a lot of CPU (e.g. up to 100% obviously). ...
- 101