178,993 questions
-1
votes
0
answers
26
views
Can not Power on Aiven Database. Migrating a Backup to another provider is also not possible [closed]
I have a Postgres database in Aiven, with a free plan. It suddently turned off and when trying to get it back on, the status of the database is stuck in Rebuilding Phase. I can not contact support on ...
- 31
0
votes
1
answer
20
views
How to import schema from a local database into a remote database in Supabase
I'm currently developing locally, with a remote database that is going to become the live, production database.
However, I have trouble applying my local changes as migrations to the remote database. ...
- 49
1
vote
1
answer
62
views
Django Can't find table during insert: LINE 1: SELECT 1 AS "a" FROM "qmgr_def_rules" WHERE "qmgr_def_rules"
I'm trying to add a row to my model, but it keeps coming back with:
django.db.utils.ProgrammingError: relation "qmgr_def_rules" does not exist
LINE 1: SELECT 1 AS "a" FROM "...
- 103
Advice
0
votes
0
replies
21
views
How to design profile view email notifications using Node.js, Bull queue and Redis?
I have a social networking site where people connect, meet and build network. User created their profile based on there interest. Users can visit others people profile and send connection request to ...
0
votes
0
answers
50
views
TimescaleDB Hypertable Performance Slower Than Normal Table for Time-Series Queries – Why?
I created two tables—one normal table and one TimescaleDB hypertable—and inserted 50 million records into each. However, I’m not seeing a significant performance difference between them. In fact, the ...
- 163
0
votes
1
answer
96
views
PostgreSQL Connection Error via DBeaver: FATAL: invalid value for parameter "TimeZone": "Asia/Calcutta"
I have a PostgreSQL database server running on my VPS. I am currently working from my local machine using an SSH connection and would like to view the database tables and data graphically for better ...
2
votes
2
answers
146
views
Why indexes don't improve performance?
This query uses my indexes according to the plan, however, they do not give any increase in query execution speed. Absolutely.
I've tried a wide variety of indexes, but none have helped. I've ...
- 31
1
vote
0
answers
87
views
Celery crashes when PgBouncer closes idle connections (idle timeouts enabled)
I’m encountering an issue when running Celery with PgBouncer and PostgreSQL after enabling idle connection timeouts.
My stack includes:
Django (served via Tornado)
Celery (workers + beat)
...
- 45
0
votes
1
answer
97
views
why is using indexes not helping my query in any way?
I have a problem. I have a query
SELECT department."name" AS "division",
COUNT(DISTINCT equipment."inventory_number") AS "count of equipment"
FROM ...
- 31
1
vote
1
answer
78
views
mock feature in SeaORM v1.1.19 makes DatabaseConnection lose the trait to clone it
Im doing a Actix Web rust backend with SeaORM, I finished and it works fine, so I'm doing some tests, SeaORM has a mock feature, which you can enable in the Cargo.toml file, but enabling it makes the ...
- 10
1
vote
1
answer
159
views
Testcontainer error: Could not find a valid Docker environment
Why am I suddenly encountering this error when running the repository tests locally?
2025-12-15 21:59:28 [ZScheduler-Worker-11] ERROR o.t.d.DockerClientProviderStrategy - Could not find a valid Docker ...
- 461
0
votes
0
answers
67
views
Function not found in [closed]
New to postgres.
Created function with 2 parameters: int and varchar.
I can see it in df
But df and running the function returns that the function do not exist.
0
votes
1
answer
129
views
How to map PostgreSQL EXPLAIN ANALYZE output to Execution Time, CPU, Memory, and I/O?
I’m trying to standardize how I report Execution Time, CPU, Memory, and I/O from PostgreSQL queries using EXPLAIN (ANALYZE, BUFFERS, FORMAT TEXT). Here’s an example of a query plan I get:
Aggregate (...
- 11
1
vote
3
answers
112
views
Postgres dump works with python os.system but not subprocess
This runs successfully:
os.system('pg_dump sdtests > /home/bret/dump.custom')
But doing it with subprocess gives an error:
command = ['pg_dump', 'sdtests', '>', '/home/bret/dump.custom']
...
- 542
0
votes
1
answer
73
views
How do I select a list of all the values of a specific field name in a recursive set of jsonb data in Postgres?
I have a column named layout in a table named pages which contains JSON.
In this case, the JSON actually represents the HTML of a page. Information is infinitely nested, just as an HTML page would be. ...
- 6,126
