Questions tagged [postgresql]

Question 1

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 ...

Question 2

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 ...

Question 3

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. ...

Question 4

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 ...

Question 5

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 ...

Question 6

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 ...

Question 7

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 ...

Question 8

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 ...

Question 9

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 ...

Question 10

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 ...

Question 11

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: ...

Question 12

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 ...

Question 13

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 ...

Question 14

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 ...

Question 15

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 ...

Question 16

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 ...

Question 17

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 ...

Question 18

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 ...

Question 19

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 ...

Question 20

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 "...

Question 21

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 ...

Question 22

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 ...

Question 23

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, ...

Question 24

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 = ...

Question 25

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 ...

Question 26

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 ...

Question 27

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 ...

Question 28

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 ...

Question 29

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 ...

Question 30

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 ...

Question 31

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 ...

Question 32

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 ...

Question 33

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 ...

Question 34

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 ...

Question 35

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 ...

Question 36

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 ...

Question 37

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-...

Question 38

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 ...

Question 39

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 ...

Question 40

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 ...

Question 41

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 ...

Question 42

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 ...

Question 43

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 ...

Question 44

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.

Question 45

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 ...

Question 46

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 ...

Question 47

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 ...

Question 48

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). ...

Question 49

I tried using below playbook to install postgres 12 on my ubuntu machine on both 22 and 23 versions of ubuntu. For installating postgres and set a default password to postgres user and create a new ...

Question 50

I've got DataFusion and Cloud SQL Postgres up and running in a single GCP project. I can connect to my postgres instance successfully using pgAdmin (as long as I add my IP address to the allowed ...