Securing PostgreSQL presentation slides from PDXPUG PostgreSQL Day 2018 are now available for download.

PostgreSQL's CHAR type pads with spaces and silently trims them during operations, creating bizarre behaviors that surprise most developers.

LOCK TABLE might seem tempting for serializing access, but it blocks autovacuum and replicates to secondaries. Use advisory locks instead.

Use pg_rewind to reattach a former primary as a secondary without a full rebuild.

PostgreSQL offers three ways to get the current time: now(), statement_timestamp(), and clock_timestamp(). Learn which one to use and when.

PgBouncer's self-signed TLS setup requires an easy-to-forget CA file parameter—here's what you need to know.

Promoting a secondary and rewinding the old primary with pg_rewind is fast—until a timing bug leaves your new secondary unable to recover.

Google's new checksum verification tool sparked backup integrity concerns, but PostgreSQL's page checksums have been solid since 9.3—some backup tools just…

Pgpool2 won't connect after you fix a hostname? Delete the pgpool_status file—it caches host status across restarts and won't update automatically.

Dive into PostgreSQL replication strategies with slides from PerconaLive 2018, covering practical approaches to keeping your databases in sync.