Awesome Postgres

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

PostgreSQL, often simply Postgres, is an object-relational database (ORDBMS). PostgreSQL is ACID-compliant and transactional. (see more: wikipedia:PostgreSQL, PostgreSQL.org)

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

Contents

• Awesome Postgres
  • High-Availability
  • Backups
  • GUI
  • Distributions
  • CLI
  • Server
  • Monitoring
  • Extensions
  • Work Queues
  • Optimization
  • Utilities
  • Language bindings
  • PaaS (PostgreSQL as a Service)
  • Docker images
  • Kubernetes
• Resources
  • Tutorials
  • Blogs
  • Documentation
  • Newsletters
  • Videos
  • Community
  • Roadmaps
  • External lists

High-Availability

• autobase - Autobase for PostgreSQL® is an open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters.
• BDR - BiDirectional Replication - a multimaster replication system for PostgreSQL
• Patroni - Template for PostgreSQL HA with ZooKeeper or etcd.
• Spock - 100% open-source logical multi-master PostgreSQL replication.
• Stolon - PostgreSQL HA based on Consul or etcd, with Kubernetes integration.
• pglookout - Replication monitoring and failover daemon.
• repmgr - Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.
• Slony-I - "Master to multiple slaves" replication system with cascading and failover.
• PAF - PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
• SkyTools - Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.
• pg_auto_failover - Postgres extension and service for automated failover and high-availability.
• pgrwl - Stream write-ahead logs (WAL) from a PostgreSQL server in real time. A drop-in, container-friendly alternative to pg_receivewal.

Backups

• Barman - Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.
• OmniPITR - Advanced WAL File Management Tools for PostgreSQL.
• pg_probackup – A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.
• pgBackRest - Reliable PostgreSQL Backup & Restore.
• pgbackweb - A Complete Docker-based Postgres backup and maintenance tool with Web UI.
• pg_back - pg_back is a simple backup script
• pghoard - Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).
• postgres-backup-oss - A handy Docker container to periodically backup PostgreSQL to Alibaba Cloud Object Storage Service (OSS)
• wal-e (obsolete) - Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.
• wal-g - The successor of WAL-E rewritten in Go. Currently supports cloud object storage services by AWS (S3), Google Cloud (GCS), Azure, as well as OpenStack Swift, MinIO, and file system storages. Supports block-level incremental backups, offloading backup tasks to a standby server, provides parallelization and throttling options. In addition to Postgres, WAL-G can be used for MySQL and MongoDB databases.