pgspider griddb fdw 通过固定列表server 连接配置

OPTIONS(notification_member ‘<ip>:<port>,<ip>:<port>,<ip>:<port>,...‘,clustername ‘<cluster-name>‘)

// 创建扩展

CREATE EXTENSION griddb_fdw;

// 创建外部server

CREATE SERVER griddb_svr FOREIGN DATA WRAPPER griddb_fdw OPTIONS(notification_member ‘griddb-1:10001,griddb-2:10001,griddb-3:10001‘,clustername ‘defaultCluster‘);

// 创建用户映射

CREATE USER MAPPING FOR public SERVER griddb_svr OPTIONS(username ‘admin‘, password ‘admin‘);

// 导入schema

IMPORT FOREIGN SCHEMA griddb_schema FROM SERVER griddb_svr INTO public;