179,006 questions
0
votes
0
answers
11
views
Problem with connection to PostgreSQL through WireGuard
WireGuard settings:
Server: wg0.conf
[Interface]
Address = 10.8.0.1/24
SaveConfig = false
ListenPort = 51820
PrivateKey = <PrivateKey>
[Peer]
PublicKey = <PublicKey>
AllowedIPs = 10.8.0.10/...
- 45
Advice
0
votes
0
replies
30
views
Migrating ServiceNow On-Prem DB from MariaDB to PostgreSQL during ITOM implementation
I am currently implementing ITOM (Discovery and Service Mapping) on a Self-Hosted (On-Premises) ServiceNow instance. The current backend is MariaDB, and we are planning a migration to a different DB ...
- 23
2
votes
0
answers
23
views
Prisma 7: migrate dev hangs on Supabase pooler (port 6543) because prisma.config.ts lacks directUrl support
I am using Prisma 7.4.0 with Supabase and I'm facing a blocking issue with migrations.
When I run npx prisma migrate dev, the process hangs indefinitely at this point:
Loaded Prisma config from prisma....
- 11
-3
votes
0
answers
40
views
PolarDB Standby node cannot provide read-only service despite normal streaming replication [closed]
Description
I am testing the failover capabilities of a PolarDB PostgreSQL 14 primary-standby cluster. After killing the primary node, I promote the standby node to primary and attempt to downgrade ...
0
votes
0
answers
27
views
Doctrine PingableConnection replacement for Postgres
In long running processes with the symfony scheduler we had the problem, that the DB connection got lost and was not refreshed.
Our Database is Postgres.
Doctrine DBAL used to have a ...
- 6,046
Advice
0
votes
1
replies
43
views
Postgres Index monitoring query
I also have pgstattuple extension, Is there a query to check status (bloat etc) for all indexes in the database that can give insights on what to do (REINDEX)
- 1
-1
votes
0
answers
39
views
How to configure PolarDB-PG logindex retention policy to reduce disk usage?
I am running PolarDB and I've noticed that the pg_logindex directory is consuming a significant amount of disk space.
I understand that PolarDB already implements an automatic mechanism for logindex ...
- 1
Best practices
0
votes
2
replies
24
views
Ducklake Connection Pooling for Postgres Backend
I am currently experimenting with a DuckDB / Ducklake setup using postgres as a catalog. I am experimenting with a handful of concurrent writers and many concurrent readers.
To reduce stress on the ...
- 93
1
vote
1
answer
22
views
Odoo 16: psycopg2.InterfaceError: Cursor already closed on second onchange call
I have a stored computed field on a custom model that calls a helper method decorated with @ormcache. The method does a search() and returns a recordset:
from odoo import api, models
from odoo.tools ...
- 618
0
votes
1
answer
54
views
PostgreSQL function returns date format differently from table
In PostgreSQL (using DBeaver as a client), when I return the same query from a function as from a table for a timestamptz field, the time element appears differently (and is then handled by downstream ...
Best practices
0
votes
1
replies
20
views
Barman postgresql backups
Is it possible to run barman on ubuntu 24.04 (Postgres 16) while the database server is on rhel 7 (Postgres 14)
I am interested since it can achieve low RPO's
- 1
3
votes
1
answer
55
views
How to guarantee pg_advisory_xact_lock execution order?
We are extensively using Postgres advisory locks to re-centralize a distributed software system to publish to an API which requires aggregated data.
Rarely, multiple locks have to be acquired which we ...
- 1,878
-1
votes
1
answer
48
views
Get all indexes on string columns Postgres [closed]
How do I get all indexes that would need reindexing after glibc upgrade ?
my current query:
SELECT
n.nspname AS schema,
c.relname AS table,
i.relname AS index,
a....
- 1
-4
votes
1
answer
43
views
Why can't we change password_encryption to scram-sha-256 on PolarDB for PostgreSQL 16, while community PG 16 defaults to it? [closed]
Problem
We are running PolarDB for PostgreSQL (version 16) on Alibaba Cloud. We noticed that password_encryption is still set to md5 by default:
SELECT name, setting, source, enumvals
FROM ...
- 1
-4
votes
1
answer
84
views
Query ran successfully but return no results [closed]
The study found that international students have a higher risk of mental health difficulties than the general population, and that social connectedness (belonging to a social group) and acculturative ...
- 1
