Explore realtime community troubles, AI diagnostics, verified fixes and troubleshooting workflows across gaming, hardware, networking, software and infrastructure.
Show:
## Environment PostgreSQL 14.5 primary on Debian 11 (dedicated server), partitioned table (range partitions by date, ~120 partitions), application servers connect via PgBouncer v1.17.0 in transaction pooling mode; app uses psycopg2 with prepared sta...
## Environment PostgreSQL 13.8 on Debian 11 VM (8 vCPU, 32 GB RAM), primary and one logical replica on separate hosts; publisher uses pglogical extension for cross-datacenter replication; WAL archived to local filesystem; nightly bulk import job (CO...
## Environment Primary and one async replica hosted in same data center (MySQL 8.0.33), replication configured using GTID and a replication user with REPLICATION SLAVE. Replication was healthy for weeks. Intermittent 10–30s packet loss events report...
## Environment PostgreSQL upgraded in-place from 13.5 to 14.2 on Ubuntu 20.04 LTS. A third-party C extension (installed from distro package and also a site-built variant) is listed in shared_preload_libraries and the cluster runs on a 16-core VM wit...
## Environment Primary: PostgreSQL 13 on bare-metal (12 cores, 64GB), Logical replication slot streaming to replica on PostgreSQL 13; large table (~2 TB, 500M rows) in production; ALTER TABLE ADD COLUMN ... DEFAULT X NOT NULL executed during low-tra...
## Environment PostgreSQL 13.8 on CentOS 7 hosts, plperl installed and used for several stored procedures. System Perl recently upgraded from 5.16 to 5.30 via vendor-supplied package; perl-modules and shared libraries updated. PostgreSQL installed f...
## Environment PostgreSQL 13.7 primary on Debian 11 (8-core VM), three synchronous replicas on separate hosts. Streaming replication over TLS (server certs) through a TCP load balancer that enforces SSL session renegotiation every 60s. wal_level = r...
## Environment PostgreSQL 13 cluster: primary on cloud VM (8 vCPU, 32GB RAM), standby streaming replication over 1 Gbps link; autovacuum aggressive tuning with autovacuum_max_workers=20 and autovacuum_naptime=10s, several large partitioned tables wi...
## Environment Java Spring Boot application (OpenJDK 11, PostgreSQL JDBC driver 42.x) connecting via a connection pool (HikariCP) to PostgreSQL 13 on Debian. The app issues parameterized queries against a large date-partitioned table using PreparedS...
## Environment Primary: PostgreSQL 13.6 on Ubuntu 20.04, physical host with 1 Gbps NIC. archive_mode = on, archive_command = 'rsync --relative %p backup@backup-host:/data/pg_wal/%f'. pg_basebackup run from backup host to create base backup while WAL...