PostgreSQL

Awesome Postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

:elephant: Contributions welcome. Add links through pull requests or create an issue to start a discussion. Please take a look at the contribution guidelines.

Backup and recover a PostgreSQL DB using wal-e - Tutorial about setting up continuous archiving in PostgreSQL using wal-e.
Operations cheat sheet - Operations cheat sheet from PostgreSQL Wiki.
PG Casts - Free weekly PostgreSQL screencasts by Hashrocket.
Postgres Guide - Guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within PostgreSQL.
PostgreSQL Exercises - Site to make it easy to learn PostgreSQL by doing exercises.
tutorialspoint PostgreSQL tutorial - Very extensive collection of tutorials on PostgreSQL
postgresDBSamples - A collection of sample postgres schemas
PostgreSQL Primer for Busy People - A collection of the most common commands used in PostgreSQL
pg-utils - Useful DBA tools by Data Egret
pagila - Pagila, Postgres Sample Database
SQL Syntax Cheat Sheet - Comprehensive SQL syntax reference covering window functions, CTEs, and PostgreSQL-specific syntax (UPSERT, JSON queries, array operations).

Planet PostgreSQL - Blog aggregation service for PostgreSQL.
Andrew Dunstan's PostgreSQL and Technical blog
Bruce Momjian's PostgreSQL blog
Craig Kerstiens PostgreSQL posts - Set of posts on PostgreSQL cool features, tips and tricks.
Database Soup - Josh Berkus' blog.
Michael Paquier's blog
Percona's PostgreSQL blog posts
Robert Haas' blog
select * from depesz; - Hubert Lubaczewski's blog.
Metis Blog - Set of posts on PostgreSQL, SQL databases, performance, and tuning.
Digoal's PostgreSQL and Technical blog(Chinese Language)
Pigsty blog / PostgreSQL - Blog by the author of PIGSTY with insightful articles on PostgreSQL (as well as databases and cloud infrastructure).
BigData Boutique Blog / PostgreSQL - Blog by the BigData Boutique team, mostly with analytics focus).

PostgreSQL Mistakes and How to Avoid Them
The Internals of PostgreSQL - A free e-book by Hironobu Suzuki
PostgreSQL 14 Internals - A free e-book by Egor Rogov
Lift the Elephant - A practical guide to scaling Postgres in production, covering tuning, connection pooling, partitioning, and high availability.

Wiki - user documentation, how-tos, and tips 'n' tricks
pgPedia - An encyclopedia of things related to postgreSQL.
create_pg_super_document - A project that aim to generate documentation for all symbols in the PostgreSQL codebase using AI agents

Postgres Weekly - Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL.
pgMustard newsletter - Monthly newsletter that contains Postgres performance articles and videos.
pgsql-hackers Weekly Digest - Weekly digest of the pgsql-hackers mailing list that provides a list of active threads, thread summaries, and more.

Citus Data Youtube channel - Citus related videos
EnterpriseDB Youtube channel - EnterpriseDB related videos
Postgres Conference Youtube channel - Conference videos
Scaling Postgres - Postgres video blog series by Creston Jamison
PostgresTV Youtube channel - Postgres talks, hacking sessions, interviews, and podcast episodes

Mailing lists - Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community.
Reddit - A reddit community for PostgreSQL users with over 12000 users
Slack - Slack workspace for Postgres with over 20k members
Telegram - Several groups for PostgreSQL in different languages: Russian >4200 people, Brazilian Portuguese >2300 people, Indonesian ~1000 people, English >750 people
#postgresql on Freenode - The most popular IRC channel about Postgres on Freenode with over 1000 users
Discord - A Discord server for Postgres with over 6k members

Wikipedia admin tools list - Comparison of database administration tools on Wikipedia
PostgreSQL Wiki GUI tools list - Community Guide to PostgreSQL GUI Tools
PostgreSQL Wiki Foreign Data Wrappers list - Foreign data wrappers