PostgreSQL
Object-relational database.
Contents
Backups
A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.
A Complete Docker-based Postgres backup and maintenance tool with Web UI.
Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).
A handy Docker container to periodically backup PostgreSQL to Alibaba Cloud Object Storage Service (OSS)
(obsolete) – Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.
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.
Monitoring
check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.
Nagios check_postgres plugin for checking status of PostgreSQL databases.
Coroot is an open-source APM & Observability tool, a DataDog and NewRelic alternative. Powered by eBPF for rapid insights into system performance.
Real-time performance monitoring, including pre-made graphs for ease of setup (Commercial Software)
Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.
Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.
Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.
Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards.
The automatic indexer for Postgres. Detects slow queries and creates indexes if configured to do so.
Active Session History for PostgreSQL. Samples pgstatactivity once per second via pg_cron, stores encoded snapshots, and provides 32 SQL functions for wait event analysis. Pure SQL, no extensions, works on managed providers (RDS, Cloud SQL, Supabase, etc.).
Extensions
Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes.
Postgres binding as extension for crypto library Themis, providing various security services on PgSQL's side.
Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch.
Platforms
Utilities
Cloud-native database gateway and framework for building data-driven applications. Like API gateways, for databases.
Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
The NServiceBus.Transport.PostgreSql library allows .NET developers to use a PostgreSQL database as a message broker. (Commerical Software)
Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.
Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.
Browser extension to redirect PostgreSQL docs links to the current version.
Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.
Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or Kubernetes.
Tool that extracts and provides metrics for your PostgreSQL database.
Instant GraphQL API or GraphQL schema for your PostgreSQL database
PostgreSQL high-availability cluster with auto-failover and automated cluster recovery.
A lightweight PostgresSQL LISTEN/NOTIFY daemon built on top of node-postgres.
Tool to compare database schemas, with capability to accept some persistent differences
Tool for easy initialization / updating of the structure of PostgreSQL tables, migration alternative (Node.js).
Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.
Tool to build, maintain and execute a regression testing suite for SQL queries.
a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres database.
Kubernetes
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.
A comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments.
Percona Operator for PostgreSQL based on Crunchy Data operator.
Everest Operator is a Kubernetes Operator responsible for managing the lifecycle of MySQL, MongoDB, and PostgreSQL databases. It leverages Percona's Kubernetes Operators for MySQL, MongoDB, and PostgreSQL under the hood but provides a unified API and a single pane of glass for managing all three database types.
Tutorials
GUI
Distributions
CLI
Atlas is a tool for managing and migrating database schemas using modern DevOps principles.
CLI (and Golang library) for diffing Postgres schemas and generating SQL migrations with minimal locking.
Server
Security
High-Availability
Autobase for PostgreSQL is an open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters.
Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.
PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.
Postgres extension and service for automated failover and high-availability.