pgspider redis fdw pub && sub 试用

version: "3"
services: 
  redis:
    image: redis
    ports:
    - "6379:6379"
  pg-redis:
    image: dalongrong/pgspider:redis
    ports:
    - "5432:5432"
    environment: 
    - "POSTGRES_PASSWORD:dalong"

docker-compose up -d

// 创建扩展
CREATE EXTENSION redis_fdw;
// 创建server
CREATE SERVER redis_server 
     FOREIGN DATA WRAPPER redis_fdw 
     OPTIONS (host ‘redis‘, port ‘6379‘);
// 创建用户映射
CREATE USER MAPPING FOR postgres
     SERVER redis_server
     OPTIONS (password ‘demo‘);
// 创建表映射
CREATE FOREIGN TABLE rft_pub(
      channel TEXT,
      message TEXT,
      len INT
     ) SERVER redis_server
    OPTIONS (tabletype ‘publish‘);

redis-cli
SUBSCRIBE demoapps

插入数据：
insert into rft_pub(channel,message) values(‘demoapp‘,‘dalong‘);