Forgotten the postgres superuser password? Single-user mode lets you reset it without losing access to your database.

Discover why Uber's infrastructure choices don't tell the whole story about PostgreSQL's capabilities and design tradeoffs.

Corruption War Stories from PGConf 2017 are now available. Learn what went wrong and how to prevent data corruption disasters.

Django and PostgreSQL presentation slides are now available for download from PGConf.

Your DBA is unavailable and PostgreSQL is down. Learn practical troubleshooting and operational basics from a PGConf US 2017 tutorial.

Dive into real-world PostgreSQL corruption scenarios and how to recover from them.

Django threw a cryptic "dictionary update sequence" error—but the real culprit was a forgotten `name=` parameter in a URL configuration.

PostgreSQL's query planner guesses exactly 200 distinct values when it lacks statistics on a parent partitioned table, leading to wildly inaccurate cost…

Django's "Site matching query does not exist" error usually means you forgot to create a site record or set SITE_ID in settings—here's how to fix it.

Composite indexes on (A, B, C) can't help queries on just (B)? That's not technically true, but it's still good advice.