pglogical
pgcapture
Our great sponsors
pglogical | pgcapture | |
---|---|---|
2 | 2 | |
935 | 172 | |
2.1% | 4.1% | |
3.9 | 8.5 | |
16 days ago | 2 months ago | |
C | Go | |
GNU General Public License v3.0 or later | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pglogical
- Pglogical 2
-
How to mirroring database in postgresql
You may want to look into pglogical since it replicates sequences as well. I don't think postgres' built-in logical replication replicates sequences.
pgcapture
-
Concurrency mutex patterns general question
Use Change Data Capture techniques to synchronize your replicas. This tool may help you if you are using PostgreSQL https://github.com/rueian/pgcapture
- A Scalable Netflix DBLog (A Change Data Capture) Implementation for PostgreSQL
What are some alternatives?
symmetric-ds - SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.
jet - Type safe SQL builder with code generation and automatic query result data mapping
peerdb - Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage
transfer - Database replication platform that leverages change data capture. Stream production data from databases to your data warehouse (Snowflake, BigQuery, Redshift) in real-time.
sqlite-wf - Simple visual ETL tool
go-deadlock - Online deadlock detection in go (golang)