178,859 questions
Score of -4
0 answers
89 views
Best practice to delete data when tenant off-boards [closed]
We need to implement a tenant offboarding/data deletion pipeline across multiple microservices using shared tables in PostgreSQL and ClickHouse. All relevant tables contain a tenant_id.
We're weighing ...
- reputation score 704
Score of -1
0 answers
46 views
Debezium PostgreSQL on Azure Flexible Server: managed-identity token works but replication=database connection fails auth
I'm running the Debezium PostgreSQL source connector on Kafka Connect and authenticating to Azure Database for PostgreSQL Flexible Server using a user-assigned managed identity via the pgjdbc auth ...
- reputation score 3717
Score of 0
1 answer
39 views
Prisma (ORM) migration command hangs open indefinitely on port 6543 instead of finishing
I am runing Prisma migrations for a NestJS application connected to a Supabase PostgreSQL database.
When I run npx prisma migrate dev --name init (or deploy) using the connection string with port ...
- reputation score 1
Score of 1
2 answers
85 views
PlanCache overhead with plan-time partition pruning in PolarDB-PG
I have a repeatable planning-time performance issue caused by the
interaction between PlanCache and plan-time partition pruning for prepared
statements on partitioned tables in PolarDB-PG.
My server ...
- reputation score 11
Score of -1
0 answers
36 views
Trouble migrating Laravel database to PostgreSQL [duplicate]
I'm having trouble migrating new tables for database and the error said
And chatgpt just bluffing around that i should add this add that to php.ini
Illuminate\Database\QueryException
could not ...
- reputation score 1
Score of 1
1 answer
115 views
Reading from Postgres DB using Polars and filter on list of strings
I want to read from my Postgres database using Polars and filter a string column based on a list of values.
E.g. assuming I have a Postgres connection called con:
mylist = ['abc', '123']
with con:
...
- reputation score 13
Score of 0
0 answers
62 views
Logical Replication between PostgreSQL v13 and v17 stuck on Initial Table Copy [migrated]
I need to perform logical replication from PostgreSQL 13 to PostgreSQL 17 as part of a migration that should require little to no downtime.
The regular apply worker is running correctly and continues ...
- reputation score 309
Score of -1
1 answer
83 views
Supabase returns 42P01: relation "a" does not exist with no line reference during migration [closed]
I'm running a SQL migration in the Supabase SQL Editor to insert a batch of vocabulary data. The migration contains inserts for levels, words, and quiz questions, wrapped in a transaction:
begin;
...
- reputation score 1
Score of -1
0 answers
56 views
Handling stale "PENDING" file upload states in PostgreSQL: Batch Quartz Sweep vs. Lazy Expiration vs. Event-Driven Delay
I am designing a direct-to-S3 file upload pipeline and need guidance on the best pattern to handle abandoned or expired upload records in PostgreSQL.
Current Architecture:
Client requests an S3 ...
- reputation score 1
Score of 3
1 answer
134 views
Does Postgres have a way to compare URLs with mixed case-sensitivity?
Some parts of URLs are case-sensitive and some are not. Specifically, the hostname is case-insensitive and the rest of the url is not. (Actually, the protocol may be case-insensitive, I'm not sure). ...
- reputation score 31
Score of 1
0 answers
77 views
GBase8c/Postgresql PL/pgSQL recursive function consuming excessive memory (Out of Memory error)
I am working on a GBase8c/PostgreSQL 16 database where I need to traverse a large, deeply nested hierarchical table (In bank anti-fraud systems, the Account Relationship Table, often called the "...
- reputation score 19
Score of 1
2 answers
155 views
Select one subset or another depending on condition in a single query
This is a problem I would like to solve with a single query, as I am working on a large dataset, and the process as it is can take up to 2 hours to complete, and additional queries would create ...
- reputation score 345
Score of -2
1 answer
194 views
Is replaying a transactional outbox in auto-increment ID order will maintain the order of events?
I'm implementing a transactional outbox pattern and trying to replay events in order.
After outbox events are published, they are stored in an inbox table on the destination. A separate process ...
- reputation score 2475
Score of -1
0 answers
125 views
How to handle configurable alert deduplication in a vehicle tracking system
We are building a vehicle tracking system where tracking devices continuously generate events.
For example, if a vehicle is overspeeding, the device may send an overspeed event every second:
10:00:00 -...
- reputation score 29
Score of 0
1 answer
108 views
Creating Table : Relation does not exist [duplicate]
A look at my code inside the PGAdmin4.
I am teaching myself Db Mgmt via Coursera. One assignment is to create a db in SQL with each individual table. I keep getting the same error message that the ...
- reputation score 11
