179,082 questions
-4
votes
0
answers
24
views
PostgreSQL error while randomaly disconnected automatically on production server [closed]
I am using PosgreSQL version 11 to database store while using on production It's giving error in log file like below metioned.
Thanks in advance for help and support.
the error messages is:
"...
- 18
0
votes
2
answers
49
views
PostgreSQL solution to work easier on a specific row with multiple columns
I have a table where I want to do some statistics on each rows different columns. For example:
id
NW2020
NW2021
NW2022
NW2023
NW2024
CA2020
...
1
-299
4000
21
-325
2544
55
2
54
244
-5
-54
325
874
How ...
0
votes
1
answer
33
views
Downloaded postgres fresh with Homebrew on Mac but cannot connect
I install postgres with homebrew and verify the postgres server is running:
brew install postgresql@14
brew services restart postgresql@14
psql --version
-> psql (PostgreSQL) 14.18 (Homebrew)
I ...
- 5,228
0
votes
0
answers
23
views
Setup Sentry with remote Postgresql and Redis on Ubuntu [closed]
I want to install Sentry (self-hosted) on my Ubuntu 24.04 and communicate with my remote Postgresql server and redis, my goal is to avoid installing Postgresql & Redis on my Ubuntu server, I've ...
- 173
0
votes
1
answer
24
views
Doctrine migration ignores UniqueConstraint
Tech stack: Symfony 7.3 + Doctrine 2 + PostgreSQL.
I would like to create unique index for two columns - app_id and user_id - for user_mobile_apps table.
Entity:
declare(strict_types=1);
namespace ...
- 1,314
0
votes
0
answers
16
views
.NET - TestContainers many instance PostgreSql conflict
I'm writing integration tests in my .NET WebApi application. I'm using XUnit for this. I am using factory and collection. And everything works as expected. I run factory there I have used PostgreSql ...
- 197
0
votes
0
answers
20
views
How to deply Citus Postgres DB using docker-compose? [closed]
So I was checking for complet configurations or docker compose file for Citus Postgres DB but I think they removed it, it was throwing a 404. I need to deploy it for one of my project which has ...
- 9
0
votes
0
answers
35
views
Liquibase CamelCase SnakeCase Mismatch
I finally managed to get Liquibase work, but when I run mvn liquibase:diff (difference between Hibernate Entities and Postgres Tables) it basically don't understand that Entities Attributes are in ...
-2
votes
0
answers
18
views
Granting user access to table did not have an effect [migrated]
In a Postgres database, I created a new table "balances" in schema "schema1" (using the Postgres User).
After checking that the table had indeed been created, I ran the following ...
- 2,607
0
votes
0
answers
25
views
Postgresql, Postgis, QGIS in container launched from charliecloud
I need to migrate my work for geospatial processing (using mainly qgis processing and postgis functions from python scripts) to a HPC cluster. As neither qgis nor postgis are installed on the HPC I ...
0
votes
1
answer
32
views
use activerecord-import to upsert only when values have changed
How to use activerecord-import to upsert only when values have changed?
Body:
I'm using the activerecord-import gem in a Rails 6 app to bulk upsert data into a PostgreSQL database. Here's an example ...
- 158
-1
votes
0
answers
23
views
why drupal-postgres-docker-compose didnt work?
i have encountered the next question in a DevOps test(short version): build a docker compose file with two services: drupal, and postgresql, create a new network for them. than show the connection ...
0
votes
0
answers
25
views
Postgres restore from zip - service won't start [closed]
I'm using Postgres 17 and I'm having trouble starting the Windows service version of the DB that I backed up using a zip archive. I have an application database customdb, in a separate tablespace ...
-1
votes
3
answers
127
views
SELECT all columns except one in PostgreSQL [duplicate]
While learning, I thought of a use case where I might have to show all the columns and it's data except one particular column. For example I might want to hide the id column in a select query.
Is ...
- 27
2
votes
2
answers
72
views
Group by query to calculate percentage
I have an PostgreSQL table called my_table that looks like this:
col_a | col_b |
-------------+-------------------------------+
A | 2025-04-28 16:23:55.961 -...
- 12.8k