cyga / www_fdw

fdw extension for postgres
http://wiki.postgresql.org/wiki/WWW_FDW
123 stars 21 forks source link

undefined symbol: HeapTupleHeaderGetDatum #26

Closed lifubang closed 8 years ago

lifubang commented 8 years ago

When I CREATE EXTENSION www_fdw; The postgresql said:

ERROR:  could not load library "/usr/lib/postgresql/9.3/lib/www_fdw.so": /usr/lib/postgresql/9.3/lib/www_fdw.so: undefined symbol: HeapTupleHeaderGetDatum
********** 错误 **********

ERROR: could not load library "/usr/lib/postgresql/9.3/lib/www_fdw.so": /usr/lib/postgresql/9.3/lib/www_fdw.so: undefined symbol: HeapTupleHeaderGetDatum
SQL 状态: 58P01

\ 安装日志 **

root@937118f50889:~/www_fdw# make install
/bin/mkdir -p '/usr/lib/postgresql/9.3/lib'
/bin/mkdir -p '/usr/share/postgresql/9.3/extension'
/bin/mkdir -p '/usr/share/postgresql/9.3/extension'
/usr/bin/install -c -m 755  www_fdw.so '/usr/lib/postgresql/9.3/lib/www_fdw.so'
/usr/bin/install -c -m 644 www_fdw.control '/usr/share/postgresql/9.3/extension/'
/usr/bin/install -c -m 644 sql/www_fdw--0.1.8.sql '/usr/share/postgresql/9.3/extension/'
root@937118f50889:~/www_fdw# netstat -an | grep 5432 -c
127
root@937118f50889:~/www_fdw# ls /usr/lib/postgresql/9.3/lib/
ascii_and_mic.so     euc_kr_and_mic.so      pg_upgrade_support.so  utf8_and_cyrillic.so  utf8_and_gb18030.so    utf8_and_sjis2004.so
cyrillic_and_mic.so  euc_tw_and_big5.so     pgxs                   utf8_and_euc2004.so   utf8_and_gbk.so        utf8_and_uhc.so
dict_snowball.so     latin2_and_win1250.so  plpgsql.so             utf8_and_euc_cn.so    utf8_and_iso8859.so    utf8_and_win.so
euc2004_sjis2004.so  latin_and_mic.so       tsearch2.so            utf8_and_euc_jp.so    utf8_and_iso8859_1.so  www_fdw.so
euc_cn_and_mic.so    libpqwalreceiver.so    utf8_and_ascii.so      utf8_and_euc_kr.so    utf8_and_johab.so
euc_jp_and_sjis.so   mongo_fdw.so           utf8_and_big5.so       utf8_and_euc_tw.so    utf8_and_sjis.so
root@937118f50889:~/www_fdw#
lifubang commented 8 years ago

need to install postgresql-contrib-9.3 postgresql-client-common, and then restart the postgres server.