[pgsql-jp: 31162] dblink が使えないのですが

isizawa yuki y040403i @ yahoo.co.jp
2003年 10月 3日 (金) 14:31:55 JST


石沢と申します。
postgresqlのまだまだ初心者です。
みなさまのお力添えをかりたいのですが、宜しくお願いします
。

dblinkをcontrib/dblinkからinstallして
sampleというデータベースから読み込もうと下記のようにやっ
たのですが。

sample=# \i dblink.sql
psql:dblink.sql:20: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:25: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:30: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:35: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:40: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:51: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:56: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" notfound)
psql:dblink.sql:61: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:66: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:68: ERROR:  Relation 'dblink_pkey_results'
already exists
psql:dblink.sql:73: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:78: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:83: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:88: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
psql:dblink.sql:93: ERROR:  Load of file
/usr/local/pgsql/lib/dblink.so failed: dlopen
'/usr/local/pgsql/lib/dblink.so' failed. (Shared object
"libpq.so.3" not found)
sample=# 

というエラーがでてしまいます。
/usr/local/pgsql/lib/  にはlibpq.so.3のファイルがあるの
ですが、どうしてなのでしょう。

環境は
Free Bsd 4.8です。
postgres 7.3.2です。

宜しくお願いします。

__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/




pgsql-jp メーリングリストの案内