- Postico client for mac
- pgcli - Postgres CLI with autocompletion and syntax highlighting
- pghero - Server and query performance dashboard
- PEV - Query planning / Explain analyze visualisation
- PostgreSQL's explain analyze made readable
- Anything by Craig Kerstiens, Postgres guide by Craig
- Unique partial indexes used for a toggle button
- The FILTER clause
- Citus Data's blog is full of gold
- Hash rocket's postgresql section is golden
- Bones Moses
More as I find things…
Here are a few other sites I use (ir)regularly in my job as a Postgres DBA, in no particular order. (in case some of them are of interest to you)
PostgreSQL blog aggregator: https://planet.postgresql.org/
Search PostgreSQL mailing list: https://www.postgresql.org/list/
Hubert depesz Lubaczewski's blog: https://www.depesz.com/
Pavel Stěhule PostgreSQL tricks: http://postgres.cz/wiki/PostgreSQL_SQL_Tricks
SQL formatter: http://sqlformat.darold.net/
Postgresql data modeler: http://www.pgmodeler.com.br/
Excellent list of an "ideal" Postgres environment by Selena Deckelmann: https://gist.github.com/selenamarie/8724731
Open Postgresql Monitoring: http://opm.io/
PgBadger log analyzer: http://dalibo.github.io/pgbadger/
Backup and Recovery Manager: http://www.pgbarman.org/
repmgr (Replication Manager): http://www.repmgr.org/
wal-e, S3-based WAL archiving: https://github.com/wal-e/wal-e
Query plan visualizer: http://tatiyants.com/pev/#/plans
Description of HOT: https://raw.githubusercontent.com/postgres/postgres/master/src/backend/access/heap/README.HOT
PgBouncer connection pooler: https://pgbouncer.github.io/
Postgresql internals explained (work in progress): http://www.interdb.jp/pg/