public inbox for [email protected]
help / color / mirror / Atom feedFrom: TCapture via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: TCapture is compatible with Postgres 16 version
Date: Sun, 03 Nov 2024 19:44:41 +0000
Message-ID: <[email protected]> (raw)
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: TCapture is compatible with Postgres 16 version
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox