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,994 questions
0
votes
0
answers
61
views
PostgreSQL failed upgrade from 17 to 18 - missing data
I've got a problem with upgrade to version 18 of PostgreSQL. It is a local development server, which I usually treat as disposable and doesn't contain important data. Unfortunately, this time I've got ...
- 185
0
votes
0
answers
74
views
Postgresql critical autovacuum permission denied errors and server crashes on Windows
We have PostgreSQL 14 on Windows Server 2019 where autovacuum processes crash the database server. This is affecting our production environment with 80+ daily users, and I need urgent assistance.
...
- 1
0
votes
0
answers
64
views
Rundeck Community Will not Connect to Postgres
I am running into a problem with rundeck community version 5.16.0 where I start the service and after about a minute the service stops itself.
It looks like an error when trying to connect to the ...
- 13
2
votes
0
answers
75
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
75
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
151
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
55
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
517
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
43
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
286
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
43
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
116
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
98
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
166
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
117
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
187
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
80
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
473
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
360
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
110
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
172
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
43
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
193
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
210
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
215
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
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
1
vote
1
answer
152
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 ...
- 113
0
votes
1
answer
1k
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
1k
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
143
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
178
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
421
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
919
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 ...
- 699
0
votes
2
answers
534
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
201
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
57
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
402
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
238
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
461
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
342
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
134
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
113
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
366
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
567
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