【Postgresql】在PGXL上测试逻辑复制发布订阅功能

修改wal_level = logical

#wal_level = replica			# minimal, replica, or logical
wal_level = logical			# minimal, replica, or logical

测试开始

CREATE TABLE customers (
 login text PRIMARY KEY,
 full_name text NOT NULL,
 registration_date timestamptz NOT NULL DEFAULT now()
);

INSERT INTO customers(login, full_name) VALUES('john', 'John Doe');

CREATE PUBLICATION pub_test01 FOR table customers;

测试结束

CREATE PUBLICATION pub_test01 FOR table customers
> ERROR:  Postgres-XL does not support CREATE PUBLICATION
  DETAIL:  The feature is not currently supported
  
> 时间: 0.002s

相关资料
知乎：PostgreSQL发布/订阅
2ndquadrant：Logical Replication in PostgreSQL 10