安装redis_fdw

cd /usr/local/src

git clone https://github.com/pg-redis-fdw/redis_fdw.git

cd redis_fdw/

git checkout REL9_6_STABLE

git clone https://github.com/redis/hiredis

cd hiredis

make

make PREFIX=/usr/local/hiredis_bin install

vi Makefile

# 末尾追加

LDFLAGS += -L/usr/local/hiredis_bin/lib

export PATH=/usr/local/pgsql/bin:$PATH

make USE_PGXS=1

make USE_PGXS=1 install

2.添加环境变量。因程序运行时，会用到libhiredis.so.0.13这个动态库，所以需要把它的路径加到环境变量里

vi ~/.bash_profile  #用vi打开当前用户的bash_profile

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib  #在最后一行添加

source ~/.bash_profile

psql -U postgres

CREATE EXTENSION redis_fdw;

CREATE SERVER redis_server  FOREIGN DATA WRAPPER redis_fdw   OPTIONS (address '10.10.6.199', port '9221');

CREATE FOREIGN TABLE redis_db0 (key text, val text) SERVER redis_server OPTIONS (database '0');

CREATE USER MAPPING FOR PUBLIC SERVER redis_server OPTIONS (password 'digoal');

CREATE FOREIGN TABLE myredishash (key text, val text[]) SERVER redis_server   OPTIONS (database '0', tabletype 'hash', tablekeyprefix 'mytable:');

INSERT INTO myredishash (key, val)   VALUES ('mytable:r1','{prop1,val1,prop2,val2}');

UPDATE myredishash SET val = '{prop3,val3,prop4,val4}'  WHERE key = 'mytable:r1';

select * from myredishash;

--级联删除掉

drop  SERVER redis_server CASCADE;

参考地址：

https://yq.aliyun.com/articles/9035