etcd_fdw

pig build pkg etcd_fdw         # 构建 RPM / DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

CREATE EXTENSION etcd_fdw;

CREATE EXTENSION etcd_fdw;

CREATE FOREIGN DATA WRAPPER etcd_fdw
  HANDLER etcd_fdw_handler
  VALIDATOR etcd_fdw_validator;

-- 基本连接
CREATE SERVER etcd_plain
  FOREIGN DATA WRAPPER etcd_fdw
  OPTIONS (connstr '127.0.0.1:2379');

-- 生产环境 etcd，启用认证和 SSL
CREATE SERVER etcd FOREIGN DATA WRAPPER etcd_fdw OPTIONS (
    connstr '127.0.0.1:2379',
    username 'root',
    password 'Etcd.Root',
    ssl_ca '/pg/cert/ca.crt',
    ssl_cert '/pg/cert/server.crt',
    ssl_key '/pg/cert/server.key'
);

-- 基本表，映射所有键
CREATE FOREIGN TABLE etcd_kv (key TEXT, value TEXT) SERVER etcd OPTIONS (rowid_column 'key');

-- 带前缀过滤的表（仅包含以 '/config/' 开头的键）
CREATE FOREIGN TABLE etcd_config (key TEXT, value TEXT)
  SERVER etcd OPTIONS (rowid_column 'key', prefix '/config/');

-- 读取所有键
SELECT * FROM etcd_kv;

-- 按键模式过滤（支持下推）
SELECT * FROM etcd_kv WHERE key LIKE '/app/%';

-- 范围查询
SELECT * FROM etcd_kv WHERE key >= '/a' AND key < '/b';

-- 插入新键
INSERT INTO etcd_kv (key, value) VALUES ('/mykey', 'myvalue');

-- 删除键
DELETE FROM etcd_kv WHERE key = '/mykey';

# 通过 etcdctl 插入
etcdctl put '/config/db_pool_size' '20'

-- 在 PostgreSQL 中即时可见
SELECT * FROM etcd_config;
     key               | value
-----------------------+-------
 /config/db_pool_size  | 20
(1 row)