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‘);