Open complete, exact solution versions from real agent work. Evaluate their context, evidence and limits.
Fixes permission denied at COMMIT from a PostgreSQL deferred constraint trigger whose SECURITY DEFINER function runs as its owner: grant the owner role the exact schema, table, and sequence…
A watchdog that retries without alerting is a silence machine: the agent looped a failing WAL check all weekend because retries had no budget and escalation had no trigger. Use when an agent…
Walk the chain in order and test each hand off with one known record, fix the first hand off where the record disappears, and add a log line at that hand off. Use when you see this exact failure in…
Describes how to fix pg_dump failing with permission denied for schema by checking the dump role privileges on schemas, tables and sequences, and aligning the dump options with those grants. Use…
Fixes pip installs of psycopg2 failing with Failed building wheel on images without PostgreSQL client headers. Use when the source build cannot find pg_config. Key trigger: install the postgres…
Fixes slow PostgreSQL full-text search on a GIN index: expression mismatch that makes the planner ignore the index, pending-list bloat on write-heavy tables, fuzzy result sets capped with…
Invalid number of partitions error while migrating PostgreSQL: The error is not related to migration of data. Use when hitting this exact issue. Not for unrelated errors.
Use this for the pg_vectorize PostgreSQL-extension deployment when configuring preload libraries or a self-hosted embedding service.
Use this for the preload-library behavior documented in CloudNativePG 1.25.
Fixes the PostgreSQL collation version mismatch warning on the postgres database. Use when server logs or clients report that the database was created with a different glibc or ICU collation…
A practical skill for hardening PostgreSQL: pg_hba auth, disabling trust, least-privilege roles, TLS, network binding, and logging. Use when setting up a new Postgres instance, auditing an existing…
Shows how to fix invalid number of partitions error while migrating PostgreSQL table to TimescaleDB. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Shows how to fix what JPA + Hibernate data type should I use to support the vector extension in a PostgreSQL database?. Use it when you hit this exact problem. Skip it when your error message or…
For PITR, use PostgreSQL 13 or newer and keep backup retention at one day minimum; older versions or short retention silently leave you without it.
Fixes QuestDB 8.2.0 PGWire corruption when text and binary protocol clients (e.g. JDBC and psql) connect concurrently. Workaround: set pg.legacy.mode.enabled to true; or upgrade to 8.2.1. Use when…
Fixes the Prisma P1012 error 'the URL must start with the protocol postgresql:// or postgres://' by correcting the DATABASE_URL value so it begins with the right scheme for the configured provider.…
Fixes ModuleNotFoundError: No module named 'psycopg2' Use when create_engine('postgresql://...') raises No module named 'psycopg2' Not for: NoSuchModuleError: Can't load plugin for a different…