![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
postgresql repl
文章平均质量分 88
postgresql repl
数据库人生
专注于数据库
PostgreSQL;Oracle 11G OCA、OCP;OceanBase V2 OBCA、OBCP
展开
-
PG的复制
pg的解码器解码器是把WAL日志解析成逻辑数据的过程,将用户定阅的数据变化(即对某些表的insert/update/delete操作来带的数据变化)输出成特定的数据格式decoderbufs需要安装一堆插件,在centos上非常难于安装,官方给出的例子也是基于debein操作系统wal2jsondebezium 对wal2json的支持不好,他自己官网说的pgoutputpostgres-10 纳入了内核 以下为pgoutput解析出来的逻辑数据连接为复制pg即可以逻辑复制,也可以物理复转载 2021-09-13 15:17:20 · 1538 阅读 · 0 评论 -
postgresql 11 的逻辑复制 logical replication 之二 alter table replica identity using
os: centos 7.4.1708db: postgresql 11.7版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core) # su - postgresLast login: Sun Sep 27 13:38:50 CST 2020 on pts/2$ $ psql -c "select version();" v原创 2020-09-27 15:13:00 · 2139 阅读 · 0 评论 -
postgresql multi-master 系列 Rubyrep 之二 测试1
192.168.56.111 n1192.168.56.112 n2n1、n2 节点都已经安装了 rubyrep 。Rubyrep 要求每个表都要有主键(primary key)。版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core) # # # yum list installed |grep -i postgresqlpostgresql11.x86_64 11.8-1PGD原创 2020-06-15 16:52:47 · 787 阅读 · 0 评论 -
postgresql multi-master 系列 Rubyrep 之一 setup
Development of an open-source solution for asynchronous, master-master replication of relational databases that isridiculously easy to usedatabase independent有两种方式Standard Ruby flavorJRuby flavor本次采用 Standard Ruby flavor192.168.56.111 n1192.168原创 2020-06-15 13:43:07 · 474 阅读 · 0 评论 -
GridSQL 之一 setup
GridSQL is an open source shared-nothing clustered database system for data warehousing designed for PostgreSQL. GridSQL includes intelligence to parallelize over multiple servers for achieving faster query response times.版本# cat /etc/centos-releaseCent原创 2020-06-15 10:11:03 · 332 阅读 · 0 评论 -
PGCluster 之一 setup
PGCluster is a multi-master and synchronous replication tool of PostgreSQL based on shared-nothing architecture, developed by Atsushi Mitani and PGCluster developer’s team.The lead developer of pgCluster has moved on to pgCluster2, and all development on原创 2020-06-15 09:52:06 · 471 阅读 · 0 评论 -
postgresql multi master replication
https://www.percona.com/blog/2020/06/09/multi-master-replication-solutions-for-postgresql/原创 2020-06-10 16:02:46 · 498 阅读 · 0 评论