[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 メーリングリストの案内