Die Standard-Installation von PostgreSQL beinhaltet keine Replikationslösung (Stand August 2012). Hierfür gibt es jedoch einige separate und teilweise frei erhältliche Programme:
- Slony1
Replication is possible through the „Slony1“ PostgreSQL database replication solution, which is not a part of the core PostgreSQL distribution.
[https://www.slony.info/]
- Tungsten Replicator
Tungsten Replicator is a high performance, open source, data replication engine for MySQL and PostgreSQL.
[https://www.continuent.com/products/tungsten-replicator]
- Daffodil Replicator
Daffodil Replicator is data replication software that synchronizes data residing on corporate backend databases and desktop databases operating in the network. Daffodil Replicator performs data replication based on the ‚Publish and Subscribe‘ model (in client and server architecture). A publication is a collection of one or more tables required for data replication. A subscription is a copy of tables involved in publication on client side.
[https://sourceforge.net/projects/daffodilreplica/]
- Mammoth PostgreSQL + Replication
It is designed specifically with reliability in mind and it works with the Open Source and Command Prompt versions of PostgreSQL. Mammoth PostgreSQL + Replication supports asynchronous replication and is designed to be WAN tolerant. It uses a distributed TransactionLog to keep track of updates produced by the Master database. The system allows for multiple Slaves to receive updates in either a continuous or batch mode.
[http://www.commandprompt.com/products/mammothreplicator/]
- PGCluster
PGCluster is the synchronous replication system of the multi-master composition for PostgreSQL.
[http://pgcluster.projects.postgresql.org/]
- Bucardo
Bucardo is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations.
[https://bucardo.org/]
- Postgres-R
Postgres-R is an extension to the relational database system Postgres providing efficient, fast and consistent database replication.
[https://postgres-r.org/]
- rubyrep
An open-source solution for asynchronous, master-master replication of relational databases.
[http://www.rubyrep.org/]
- Postgres-XC
Welcome to Postgres-XC, the only known PostgreSQL cluster solution which provides for both read and write scalability.
[https://sourceforge.net/projects/postgres-xc/]
- SymmetricDS
SymmetricDS is open source software for both file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment.
[https://symmetricds.org/]
Wichtiger Hinweis: combit hat diese Software nicht getestet und kann daher weder eine Empfehlung noch eine Zusicherung für die Verwendung der Produkte abgeben.
IDKBAD001175 KBAD001175