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,999 questions
Score of 0
0 answers
18 views
Node.js + PostgreSQL job board on Hetzner VPS – realistic scaling journey from 5k to 1M monthly users?
We're building a job board on Node.js + PostgreSQL, hosted on Hetzner VPS in Central Europe. Text-only listings, no media. Core features: job listings, search, filtering, employer/candidate messaging.
...
Score of 1
0 answers
40 views
Cloud SQL PostgreSQL 14 upgrade complete but PostgreSQL 15/16 not appearing as upgrade options after 5 days
I successfully upgraded a Cloud SQL instance from PostgreSQL 13 to PostgreSQL 14 on May 13, 2026. It has now been 5 days and when I go to upgrade again, the dropdown only shows PostgreSQL 14 as an ...
Score of 0
1 answer
189 views
Debian trixie libpg5 missing PGchangePassword?
It should be there, according to the docs?
Library version is 17.9.
Score of 1
0 answers
115 views
Puppet fails with Cannot allocate memory - fork(2) on Debian Trixie VMs (Ganeti) unless RAM is increased to 8 GB
I am facing a memory-related issue on Debian Trixie VMs running on Ganeti. These VMs are used exclusively as PostgreSQL database servers.
The same Puppet configuration works fine on Debian Bullseye ...
Score of 0
2 answers
182 views
PostgreSQL: How restrict database creation?
I sort of frequently encounter software that pretends it owns all of a PostgreSQL instance and wants to create a database, even if it's already there and the software uses the account owning the ...
Score of 1
1 answer
177 views
Preventing automatic PostgreSQL restarts on a Ubuntu server after minor upgrades?
I generally like to run software updates on our (low-traffic) Ubuntu 24.04 servers during the workday, then schedule any required reboots in the middle of the night.
PostgreSQL 16 is installed from ...
Score of 1
1 answer
257 views
How to connect to PostgreSQL through WireGuard
I'm attempting to use a WireGuard tunnel to connect to PostgreSQL.
WireGuard settings:
Server: wg0.conf
[Interface]
Address = 10.8.0.1/24
SaveConfig = false
ListenPort = 51820
PrivateKey = <...
Score of 2
1 answer
130 views
Containerized Postgresql collation
I have recently become aware of possible dangers in a longer running postgres containerized instance in the form of collation issues; when updating to newer minor version containers, it is possible ...
Score of 0
0 answers
87 views
Vault Agent Injector: How to render secrets to a path without overwriting existing files there?
I'm trying to deploy PgAdmin4 to Kubernetes. I have a custom config_local.py that contains an oauth2 client secret. I have the contents of config_local.py stored in Vault. Ideally, I'd have the ...
Score of 0
0 answers
70 views
Why is Headwind MDM's Guice Injector failing to read role.orgadmin.id from config.properties on Debian 13?
Environment:
OS: Debian 13 (Trixie)
Java: OpenJDK 11.0.24
Database: PostgreSQL 17 (Manual login verified)
Server: Tomcat 9.0.98 (Manual install in /opt/tomcat)
The Issue: Tomcat starts, but the ...
Score of 0
0 answers
100 views
Setup Grafana PostgreSQL datasource
I am trying to configure PostgreSQL as data source in my new grafana service
and get an error:
stat /home/grafana/.postgresql/postgresql.crt: permission denied
We used to have grafana service on ...
Score of 0
0 answers
123 views
Systemd enforcing different permission checks on timer & service invoked rsync command vs login
Am looking to copy a postgres backup folder structure to a cifs mount. Using cp works, but using rsync gives permission denied on change dir and and stat of destination:
rsync: [sender] change_dir &...
Score of 0
0 answers
126 views
Gitlab restore projects in db from files
Does anyone know how to restore projects from Gitlab files that were deleted after updating Gitlab?
I need to restore 300+ repos and therefore they need to be restored automatically. I tried to ...
Score of 0
0 answers
287 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 ...
Score of 0
0 answers
183 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.
...