Tutorial
summary
Hands‑on setup uses Vagrant/Docker VMs, tmux and psql to show real admin tasks: pg_dump/pg_restore for logical backups (fine for <1GB, restores can take hours on big DBs), pg_basebackup + WAL archiving for PITR, and pgBouncer (listens on 6432) plus pgbench to prove connection pooling cuts backend connections. Config tips include shared_buffers sizing, checkpoint_segments (default 3 is too small), and transaction log segments of 16MB. A live PITR demo has a hiccup but pgbench/pgBouncer exercises work.
AI-written summary · about
chapters (33)
- 0:00Introduction
- 0:30Overview of covered topics
- 5:34Installing postgresql
- 9:25Setting up tmux
- 12:08Data directory basics
- 15:04Understanding data files
- 18:25Superuser concept
- 22:15Starting and stopping
- 25:27Stop and restart modes
- 30:16Restart and reload
- 35:33Troubleshooting startup
- 42:11Using psql
- 48:14Postgres extensions
- 55:57Updates and upgrades
- 1:03:37Upgrading extensions
- 1:07:20System configuration
- 1:11:40PostgreSQL configuration
- 1:16:52Transaction logs
- 1:20:36Tuning for performance
- 1:27:35Security basics
- 1:33:26Connection pooling
- 1:38:22Using pgbouncer
- 1:41:07Pgbench basics
- 1:45:50Pgbouncer pooling modes
- 1:51:25Pgpool vs pgbouncer
- 1:53:28Backup strategies
- 1:57:47Logical backups with pg_dump
- 2:03:27Physical backups (PITR)
- 2:07:16Archiving and WAL logs
- 2:13:20Base backups
- 2:18:23Restoring PITR backups
- 2:28:52Tuning pgbouncer
- 2:30:25Q&A
related talks
50mPostgreSQL Backup and Recovery Methods
59mPostgreSQL Don'ts and Dos
51mWhen Postgres Can't, You Can!
50mAn ultimate guide to upgrading your PostgreSQL installation
51mHow Postgres is misused and abused in the wild
46mAn ultimate guide to upgrading your PostgreSQL installation
51mHeavy Duty Backup w/PgBackRest
48mCTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL