PostgreSQL¶
Object-relational database.
Source
54 resources imported from dhamaniasad/awesome-postgres, dedicated to the public domain (CC0 / Unlicense). Thanks to its maintainers and contributors. Part of the KEEBOX Library · Category: Databases.
Resources¶
Tutorials¶
- 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 Access Control - The complete mental model: roles, grants, ownership, membership, policies, and default privileges as an integrated system. PDF + video, ~60 min.
- PostgreSQL Exercises - Site to make it easy to learn PostgreSQL by doing exercises.
- PostgreSQL Terminal Simulator - Guided psql lessons in a simulated terminal in the browser: meta-commands, EXPLAIN, indexes and transactions. Free, no signup.
- 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).
Blogs¶
- 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).
Books¶
- 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.
Documentation¶
- 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
Newsletters¶
- 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.
Podcasts¶
- PostgresFM - Weekly discussions about Postgres topics.
- Scaling Postgres - Weekly roundups of PostgreSQL related content.
- Path to Citus Con - Monthly interviews with people in the Postgres world.
Videos¶
- 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
Community¶
- 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
Roadmaps¶
- PostgreSQL Roadmap - A roadmap providing step wise guide to PostgreSQL.
External lists¶
- 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