Greenplum安装dblink模块

环境:centos 5, greenplum 4, postgresql 8.2.22
解压后切换到/home/gpadmin/postgresql-8.2.22/contrib/dblink目录下,
$vi Makefile
将PG_CPPFLAGS = -I$(libpq_srcdir) 设置为PG_CPPFLAGS = -I$(libpq_srcdir) -w
$make USE_PGXS=1 install
然后将dblink.so拷贝到其它segment hosts上
$ gpssh -f /host/gpadmin/host_all dblink.so ‘/usr/local/gp/lib/postgresql/dblink.so’
$createdb testdb
$psql -f dblink.sql testdb

作者: hqiang1984

量化自我,极简主义