pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It supports connection pooling,  Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure, Load balance the queries, It can execute queries in parallel to multiple servers. 

Pgpool - Middleware between PostgreSQL Client and Server

PgBouncer is  a lightweight connection pooler for PostgreSQL. It supports Session pooling, Transaction pooling, Statement pooling. It is not tied to one backend server. The destination databases can reside on different hosts. It has low memory requirements (2 kB per connection by default). This is because PgBouncer does not need to see full packets at once. 

PgBouncer - Lightweight connection pooler for PostgreSQL

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

pgAdmin - Administration and development platform for PostgreSQL

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

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
 
Ora2Pg can be used for anything from reverse engineering Oracle database to huge enterprise database migration or simply replicating some Oracle data into a PostgreSQL database. It is really easy to use and doesn't require any Oracle database knowledge other than providing the parameters needed to connect to the Oracle database.

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

Discover open source projects across all platforms

Projects

Pgpool - Middleware between PostgreSQL Client and Server

PgBouncer - Lightweight connection pooler for PostgreSQL

pgAdmin - Administration and development platform for PostgreSQL

Barman - Backup and Recovery manager for PostgreSQL

Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

TechStack

Tagcloud

License

Suggested keywords:

Projects

Pgpool - Middleware between PostgreSQL Client and Server

PgBouncer - Lightweight connection pooler for PostgreSQL

pgAdmin - Administration and development platform for PostgreSQL

Barman - Backup and Recovery manager for PostgreSQL

Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

TechStack

Tagcloud

License