Replication? do it easily with TCapture

We are very glad to announce the compatibility with PostgreSQL 16 version.

TCapture is a bidirectional multi master replication server based on a 'capture and apply' asynchronous replica engine

The actual TCapture engine is a Java application which runs as a separate program outside "PostgreSQL" , and which must be started explicitly. When TCapture is running, it will scan the transaction log of all primary databases and pick up transactions which must be replicated. Transactions which have been picked up are stored in the 'store database' , a "PostgreSQL" user database exclusively used by TCapture. In the store database, transaction is 'copied' to all store databases which have a subscription for this transaction. Transaction is then applied to the replicate databases

One of the attractions of TCapture is that it’s quite easy to set up and configure: starting from scratch, you can deploy a working replication system in less than 30 minutes. The setup procedure is described in the TCapture Guide. As always with replication, make sure you have a clear idea of the replication logic you want to implement before you start.

KEY FEATURE:

• Transactional. SQL are captured transactionally, can be coupled with surrounding business logic.
• Efficient. It capture transactions for replication from Write-Ahead Logs (WAL) instead of using triggers, eliminating overhead on master databases and significantly reduces latency
• Flexible. No limits on the number of producers or consumers, but complexity increases
• Reliable. Transactions are stored in "PostgreSQL" database – this adds the benefit of write ahead logging and crash recovery.
• Transparent. No impact on the applications already running on that database, since both engine and 'store database' can run separate from production databases.
• Easy to use. Simple to set up and configure, is an effective tool for data replication between different "PostgreSQL" versions
• Open Source. No licensing fees, but occasionally you'll have to get your hands dirty