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
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
57
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 ...
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.
...
0
votes
0
answers
63
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 ...
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 ...
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 ...
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 ...
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
512
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 ...
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 ...
1
vote
1
answer
284
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: ...
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 ...
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 ...
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 ...
0
votes
0
answers
116
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 ...