Odyssey in a connection pooler and query router for PostgreSQL, which help maintaining connections to a PostgreSQL server.

Clients connect to an Odyssey instance, which opens and routes queries to a PostgreSQL instance.

pgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements.

Orafce is a PostgreSQL extension which implements some Oracle functions that are missing in PostgreSQL, or which behave differently. More than 580 functions are implemented, including differents signatures of the same functions, for differents datatypes.

Two datatypes : varchar2 and nvarchar2 are implemented, and the table dual is created by the extension.

Pgwatch is a supervision tool, which provides Grafana dashboards from PostgreSQL statistics.

The main component of Pgwatch is a collector daemon, written in golang, which collect metrics in PostgreSQL instances and write them in a time-series database like PostgreSQL, TimescaleDB, Prometheus and even JSON files.

Pgwatch version 3 is a rewrite of the pgwatch2 tool. It offers lots of improvements, like parallel storage of metrics, Windows support, Etcd version 3 migration, docker files improvements and code refactoring.

The PostgreSQL database as time-series can use the timescaledb extension to manage data.

Pgwatch provides an optional Web UI for managing monitoring configuration like metrics and intervals.

Pgwatch uses Grafana and provides predefined dashboards, depending on the time series database used.

PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

Written in Python, Patroni is a template for PostgreSQL high availibility. Using a DCS such as Etcd, Consul or Zookeeper, Patroni runs a PostgreSQL cluster and makes it available.

Combined with Citus, Kubernetes or pgBackRest for backups, this tool is feature-rich and flexible enough to rapidly deploy PostgreSQL clusters.

Pgpool is a middleware which manages connections between a PostgreSQL server and clients. It maintains connections to the PostgreSQL server and reuse them to save the overhead of opening new one.

The use of Pgpool is transparent for both clients and PostgreSQL server, and can be used with any applications.

Pgpool provides some additional functionalities like replication, load balancing and query cache.

Barman is a disaster recovery tool aiming at making backups easily. This tool makes it easy to manage multiples PostgreSQL servers with an easy to use catologs of backups.

Barman can use differents methods to make backups : pg_basebackup or rsync, to archive transactions : pg_receivewal or ssh.

Written in Python, it’s now compatible with differents Cloud storage solutions.

Barman stands for “Backup and Recovery Manager”.

repmgr is an open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL’s built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations.

repmgr has provided advanced support for PostgreSQL’s built-in replication mechanisms since they were introduced in 9.0. The current repmgr series, repmgr 5, supports the latest developments in replication functionality introduced from PostgreSQL 9.3 such as cascading replication, timeline switching and base backups via the replication protocol.

Check_pgactivity is part of Open PostgreSQL Monitoring (OPM) which is a set of tools working above Nagios (or similar) to store into a database the perfdata retrieved by any Nagios agent and graph them in a web dashboard.

check_pgactivity is a Nagios agent dedicated to PostgreSQL. It is technically separated from OPM.