pglogical

Replication library

Provides logical replication for PostgreSQL databases with fast and efficient data transfer

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

GitHub

1k stars
84 watching
155 forks
Language: C
last commit: 3 months ago
Linked from 1 awesome list

cdcdata-transformationdata-transportdatabase-replicationetllogical-decodingpostgresqlpublish-subscribereplicationsubscriptionzero-downtime

Backlinks from these awesome lists:

Related projects:

Repository Description Stars
2ndquadrant/bdr A C-based implementation of bi-directional multi-master replication for PostgreSQL databases 359
the4thdoctor/pg_chameleon Replicates data from MySQL to PostgreSQL using Python 385
enterprisedb/repmgr Replication and failover toolset for PostgreSQL clusters 1,584
2ndquadrant/postgres Development trees for collaborative work on PostgreSQL patches and features 6
dimitri/pgcopydb Automates copying of databases between Postgres servers with parallel processing and streaming capabilities. 1,216
denishpatel/pg-clone-schema Utility to replicate Postgres schema with its objects 177
shayonj/pg-osc Tool for making schema changes in PostgreSQL with minimal locks to achieve zero downtime updates. 554
cpursley/walex A Postgres CDC library that captures changes to tables and allows callback-like actions on data in Elixir. 292
2tvenom/myreplication A client library for MySQL binary log replication protocol 193
twentyfourminutes/postgresql.bulk Provides fast bulk data insertion for PostgreSQL databases using Npgsql 3
hasura/pgdeltastream A service to stream Postgres changes over websockets using logical replication 254
circuithub/rel8 A Haskell library providing a concise and expressive interface to PostgreSQL databases 155
tmcgilchrist/postgresql-transactional A Haskell library providing a monadic wrapper around PostgreSQL query functions with predictable semantics and transactional support. 60
mickhansen/graphql-sequelize A package that simplifies the use of GraphQL with Sequelize models in MySQL and Postgres databases. 1,899
pgjdbc/r2dbc-postgresql Provides a Java driver for interacting with PostgreSQL databases using the R2DBC API. 1,016