Tagged
Postgresql guides
Hands-on guides that cover Postgresql. Every command is run and verified on a live server before it is published.
GuideRoles and Least Privilege
Build PostgreSQL roles with least privilege on a live database, then prove each limit holds by watching it refuse the operations an attacker would try.
GuideBackups That Actually Restore
Take a logical backup of a live PostgreSQL database, then do the step everyone skips: restore it into a clean database and check the row counts match.
GuideConnections and Pooling
PostgreSQL runs one process per connection. Put PgBouncer connection pooling in front so hundreds of app connections ride on a handful of real ones.
GuideTuning and Monitoring
PostgreSQL tuning and monitoring on a 1.9 GB VPS: size its memory to your RAM, then use EXPLAIN and pg_stat_statements to find the query costing you the most.