Slony-I is a "master to multiple slaves" replication system with cascading and failover. Slony-I is a system designed for use at data centers and backup sites, where the normal mode of operation is that all nodes are available. 

Slony-I - Replication System for PostgreSQL

pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards.


pgModeler - PostgreSQL Database Modeler

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers . It allows your organisation to perform remote backups of multiple
servers in business critical environments and to help DBAs during the recovery phase. Its features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups.
 
One of the coolest features of Barman is the backup catalogue, which allows you to list, keep, delete, archive and recover several full backups under the same hood.
 
Its main features: 
<ul>
 <li>
 Full hot physical backup of a PostgreSQL server
 </li>
 <li>
 Point-In-Time-Recovery (PITR)
 </li>
 <li>
 Management of multiple PostgreSQL servers
 </li>
 <li>
 Remote backup via rsync/SSH or <tt>pg_basebackup</tt> (including a 9.2+ standby)
 </li>
 <li>
 Support for both local and remote (via SSH) recovery
 </li>
 <li>
 Support for both WAL archiving and streaming
 </li>
 <li>
 Support for synchronous WAL streaming (“zero data loss”, RPO=0)
 </li>
 <li>
 Incremental backup and recovery
 </li>
 <li>
 Parallel backup and recovery
 </li>
 <li>
 Hub of WAL files for enhanced integration with standby servers
 </li>
 <li>
 Management of retention policies for backups and WAL files
 </li>
 </ul>

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers . It allows your organisation to perform remote backups of multiple
servers in business critical environments and to help DBAs during the recovery phase. Its features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups.

Barman - Backup and Recovery manager for PostgreSQL

DBBalancer is some sort of middleware that would sit in between of database clients  and a server. Currently the only server supported is Postgres, but the architecture is open to embrace more servers in a future. It's a connection pool, a load balancer and a database replicator. 

DBBalancer - Middleware btw Database client and server

Postgres-XL is a horizontally scalable open source SQL database cluster, flexible enough to handle varying database workloads like OLTP, Business Intelligence requiring MPP parallelism, Key value store, GIS Geospatial and lot more.

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

Service to extract and provide metrics on your PostgreSQL database.This tool is a CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. CLI is runnable in long running process mode, which will periodically send the gathered metrics forward.
 
It helps to collect database and cluster specific metrics like 
<ul><li>Disk usage</li><li>Rate of transactions executed per second</li><li>Time passed in seconds since the last vacuum was run per table in your database</li><li>Long running transactions</li><li>Index hit rate</li><li>Table bloat metric</li><li>Number of client connections</li><li>Lock statistics</li><li>Heap hit ratio</li><li>Replication delay</li></ul>

Service to extract and provide metrics on your PostgreSQL database. This tool is a CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. CLI is runnable in long running process mode, which will periodically send the gathered metrics forward.

PostgreSQL Metrics - Tool that extracts and provides metrics on your PostgreSQL database

Discover open source projects across all platforms

Projects

Slony-I - Replication System for PostgreSQL

pgModeler - PostgreSQL Database Modeler

Barman - Backup and Recovery manager for PostgreSQL

DBBalancer - Middleware btw Database client and server

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

PostgreSQL Metrics - Tool that extracts and provides metrics on your PostgreSQL database

TechStack

Tagcloud

License

Suggested keywords:

Projects

Slony-I - Replication System for PostgreSQL

pgModeler - PostgreSQL Database Modeler

Barman - Backup and Recovery manager for PostgreSQL

DBBalancer - Middleware btw Database client and server

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

PostgreSQL Metrics - Tool that extracts and provides metrics on your PostgreSQL database

TechStack

Tagcloud

License