178,945 questions
0
votes
0
answers
52
views
Redis SET NX still duplicating
Node.js + Redis race condition on concurrent multi-tenant writes — idempotency key not preventing duplicate transactions
I have a multi-tenant NestJS app using Redis for idempotency key caching and ...
- 1
-1
votes
1
answer
114
views
Why I can't see the the data after I move to transactions subpage?
Let's say I have 2 pages: first, that creates data (transaction) and second that displays the transactions in table. I also have navigation to those subpages ('/create-transaction' and '/transactions')...
- 11
Advice
0
votes
4
replies
111
views
Postgres - Tablesspace size issue
Postgres = Version 13
OS=Linux Redhat version 8
Our team is using single tablespace for whole database. Its size is more then 13TB. I am from Oracle background and want to suggest them to split the ...
- 35
-2
votes
0
answers
128
views
Docker Postgres slow query time using indexes [closed]
have you ever experienced slow queries on Postgres even using indexes, well i'm running it inside Docker on my Mac, and i still get up to 330ms of querying on a `existsByScopeName` call.
Consider that ...
0
votes
1
answer
81
views
"access method "columnar" does not exist" when trying to create a columnar table
I have the Citus 14 Postgres extension installed, running SELECT citus_version() returns:
Citus 14.0.1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
However ...
- 1,006
Advice
0
votes
2
replies
65
views
AWS IAM Authentication on DB level
I have an Intance with multiple DB's in it and I would like to provide access to DB's using the IAM but I am not sure if that is possible with AWS IAM on a DB level. I am pretty sure I can do it on ...
- 1,663
Best practices
1
vote
1
replies
112
views
Best design for request handling with DTOs that have a type field that defines the behaviour of an endpoint
First of all, It's my first question here, I'm not experienced enough. But I will grant all the needed information for understadning this.
I'm making an application for a college project, and I'm ...
- 1
-4
votes
0
answers
46
views
FreeRADIUS on a test authentication is failed [closed]
# Test with radtest
radtest testuser testpass123 127.0.0.1 0 nexalink_radius_secretrad
test testuser testpass123 127.0.0.1 0 nexalink_radius_secret
Sent Access-Request Id 97 from 0.0.0.0:44387 to 127....
- 3
-3
votes
0
answers
73
views
Patroni bootstrap from leader failed: Timeout [closed]
I am using PostgreSQL 16 with Patroni and since the latest patch of patroni the replica node is out of sync. I tried to reinit the cluster member but it failed with:
2026-04-29 13:36:02,576 WARNING: ...
- 13
2
votes
1
answer
80
views
Make single column values unique, except nulls
I have a Spring Boot project that is integrated with Postgres DB.
I need single column contains unique values, if not null and allow multiple null entries.
Is it possible and how to achieve this with ...
- 347
Best practices
0
votes
3
replies
78
views
What's the best approach to filtering based on max and min of a related table's values are within a specified range?
Sorry if my title is hard to parse and makes no sense, English isn't my first language, and putting my requirement into words is little difficult.
I have two tables, one called requests and one called ...
Tooling
0
votes
6
replies
143
views
PostgreSQL to MySQL Data Migration -Need a Reliable Converter
I am developing something related to db so what actually happened is I want to import the database data to my database but I am unable to import it from PostgreSQL to MySQL I need a converter is there ...
0
votes
1
answer
76
views
Postgres automatically converting date and timestamp fields to timestamptz
I have a view which is built on a CTE.
create or replace view viewname
as
WITH all_dates AS
(
SELECT generate_series
(
( SELECT min(date_trunc('day'::text, problem_time))::date AS min
...
-1
votes
0
answers
70
views
PostgreSQL ERROR: relation does not exist after running migrations with Sequelize
I'm running a Node.js app with Sequelize ORM and PostgreSQL. After running migrations, my app throws ERROR: relation "users" does not exist when trying to query the table.
My migration file ...
Advice
1
vote
2
replies
98
views
PostgreSQL Logical Replication – Converting UPDATE Operations to INSERTs on Subscriber (Append-Only Design)
[tag:Hi,
I have a question regarding native logical replication behavior in PostgreSQL.
In my setup, I want to achieve the following on the subscriber side:
Maintain an append-only table (no updates)
...
