Pg_replicatelogical
Replicate DBs using Postgres' built-in test_decoder logical replication plugin.
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Awesome Postgres | 8,928 | a month ago | 72 | cc0-1.0 | ||||||
| A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql | ||||||||||
| Realtime | 6,113 | a day ago | 2 | May 01, 2021 | 35 | apache-2.0 | Elixir | |||
| Broadcast, Presence, and Postgres Changes via WebSockets | ||||||||||
| Patroni | 5,738 | 1 | a day ago | 67 | August 03, 2023 | 57 | mit | Python | ||
| A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes | ||||||||||
| Wal E | 3,327 | 14 | 2 years ago | 33 | February 04, 2020 | 91 | bsd-3-clause | Python | ||
| Continuous Archiving for Postgres | ||||||||||
| Lealone | 2,299 | 8 days ago | 4 | March 14, 2023 | 16 | other | Java | |||
| 比 MySQL 快10倍的 OLTP 数据库 | ||||||||||
| Cloudnative Pg | 1,822 | 18 hours ago | 61 | July 27, 2023 | 164 | apache-2.0 | Go | |||
| CloudNativePG is a Kubernetes operator that covers the full lifecycle of a PostgreSQL database cluster with a primary/standby architecture, using native streaming replication | ||||||||||
| Repmgr | 1,415 | 3 months ago | 133 | other | C | |||||
| A lightweight replication manager for PostgreSQL (Postgres) | ||||||||||
| Wal2json | 1,108 | 4 months ago | 1 | March 03, 2021 | 22 | bsd-3-clause | C | |||
| JSON output plugin for changeset extraction | ||||||||||
| Postgres | 1,081 | a day ago | 40 | postgresql | Shell | |||||
| Unmodified Postgres with some useful plugins | ||||||||||
| Docker Postgresql | 1,008 | 3 months ago | 48 | mit | Shell | |||||
| Dockerfile to build a PostgreSQL container image which can be linked to other containers. | ||||||||||
Alternatives To Pg_replicatelogicalSelect To Compare
Alternative Project Comparisons
Readme
pg_replicatelogical
Replicate some or all of a Postgres database using logical replication and the built-in test_decoder.
Install
pg_replicatelogical is a command line tool. To install, run:
go install github.com/nickelser/pg_replicatelogical
This will give you the pg_replicatelogical command, assuming your Go paths are setup correctly.
Usage
pg_replicatelogical --source=postgres://user:[email protected]/sourcedb --target=postgres://user:[email protected]/targetdb --create --slot=users_events_slot_1 # run --create only once, per slot you need!
pg_replicatelogical --source=postgres://user:[email protected]/sourcedb --target=postgres://user:[email protected]/targetdb --tables=public.users,public.events --slot=users_events_slot_1
TODO: more examples! use pg_replicatelogical --help for the full help text.
Contributing
Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs and submit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features
Popular Replication Projects
Popular Postgresql Projects
Popular Data Storage Categories
Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Golang
Database
Postgresql
Decoder
Replication