PostgreSQL

PgAdmin is a GUI program for managing PostgreSQL, written in Python, but it's quite dated and requires some additional configuration.

Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.

Some tips for interacting between PostgreSQL and Bash.

Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.

PostgreSQL functions have three volatility levels by default. Proper use can significantly improve performance.

Use Distinct On extension clause to quickly find records with maximum/minimum values within groups

Cars need oil changes, databases need maintenance. For PG, three important maintenance tasks: backup, repack, vacuum

Backup is the foundation of a DBA's livelihood. With backups, there's no need to panic.

Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.

PgBackRest is a set of PostgreSQL backup tools written in Perl