实现PostgreSQL逻辑复制实战复制相对物理复制来说是非常方便 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 特性 逻 辑 解 码 复 制 槽 位 技 术 自定义输出插件 自动导出快照 无 D B 限 制 logical 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 复制槽技术 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 自定义输出插件 场景1 场景2 场景1 规则2 用户可以根据自己的需要自定义输出插件,根据不同 的场景定义不同的输出规则。也可以在相同的场景定 义不同的规则 2016Postgres中国用户大会 Postgres Conference 可以直接解析的SQL语句,并通过槽技术向不同DB 进行传递,从而实现不同DB数据库的复制。 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 如何自定义输出插件 我们所要实现以下几个回调函数: LogicalDecodeStartupCB startup_cb; LogicalDecodeBeginCB begin_cb; LogicalDecodeChangeCB0 码力 | 17 页 | 1.90 MB | 1 年前3
 PostgreSQL 14.10 DocumentationInterface Definition ............................................................. 2471 62.1. Basic API Structure for Indexes ................................................................ 2471 62.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); 191 Data Types The non-default GIN operator class jsonb_path_ops does not support @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 3032 页 | 13.27 MB | 1 年前3
 PostgreSQL 14.10 DocumentationMethod Interface Definition ....................................................... 2338 62.1. Basic API Structure for Indexes .......................................................... 2338 62.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2871 页 | 13.38 MB | 1 年前3
 PostgreSQL 13.13 DocumentationMethod Interface Definition ....................................................... 2254 61.1. Basic API Structure for Indexes .......................................................... 2254 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2782 页 | 13.00 MB | 1 年前3
 PostgreSQL 12.17 DocumentationMethod Interface Definition ....................................................... 2259 61.1. Basic API Structure for Indexes .......................................................... 2259 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2786 页 | 12.72 MB | 1 年前3
 PostgreSQL 12.17 DocumentationInterface Definition ............................................................. 2389 61.1. Basic API Structure for Indexes ................................................................ 2389 61.2. Index example of creating an index with this operator class is: 189 Data Types CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2943 页 | 12.61 MB | 1 年前3
 PostgreSQL 13.14 DocumentationInterface Definition ............................................................. 2387 61.1. Basic API Structure for Indexes ................................................................ 2387 61.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2940 页 | 12.89 MB | 1 年前3
 PostgreSQL 9.6.24 Documentation.............................................672 25.3.3. Making a Base Backup Using the Low Level API .........................................673 25.3.3.1. Making a non-exclusive low level backup .. Definition ............................................................................2263 59.1. Basic API Structure for Indexes ............................................................................ Table 9-43.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator0 码力 | 2814 页 | 6.58 MB | 1 年前3
 PostgreSQL 9.6.24 Documentation
.............................................637 25.3.3. Making a Base Backup Using the Low Level API ..................................638 25.3.3.1. Making a non-exclusive low level backup ......... Definition .....................................................................2140 59.1. Basic API Structure for Indexes .........................................................................2140 Table 9-43.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator0 码力 | 2661 页 | 6.53 MB | 1 年前3
 PostgreSQL 10.23 DocumentationInterface Definition ............................................................. 2193 60.1. Basic API Structure for Indexes ................................................................ 2193 60.2. Index Table 9.44.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator operator only. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2727 页 | 11.93 MB | 1 年前3
共 41 条
- 1
 - 2
 - 3
 - 4
 - 5
 













