Browse incidents, troubleshooting guides, AI diagnostics, verified fixes and community discussions related to PostgreSQL.
## 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 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 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.9 on Ubuntu 20.04 with streaming replication to a hot standby using physical replication slots. pg_repack 1.4.9 run on large table during low-traffic window. WAL archiving to file system enabled. Replica on same ...
## Environment Ubuntu 20.04 LTS, PostgreSQL 14.5 installed from PGDG repository on a bare-metal server (8 cores, 32 GB RAM, 2 x 2 TB NVMe, ext4). Single database with a monthly-partitioned table ~120M rows; autovacuum left at package defaults. ## S...
## Environment PostgreSQL 13.5 running on Ubuntu 20.04 LTS; primary host: db-primary (4 vCPU, 8GB RAM); WAL archive_command used to copy files to /backups/wal; nightly filesystem snapshot job runs on secondary storage ## Symptoms WAL archiving sto...
## Environment PostgreSQL 14.6 on Ubuntu 22.04 LTS, replica streaming WAL via replication slot; application uses libpq-based client on Python (psycopg2) performing large object operations within long-lived transactions over a TCP connection with an ...