dblink怎么装

zhaopingzi

h-4.1$ psql -f /opt/pgsql/share/extension/dblink.sql -p 5444 pgpool
psql:/opt/pgsql/share/extension/dblink.sql:1: ERROR:  could not access file "$libdir/dblink": No such file or directory
psql:/opt/pgsql/share/extension/dblink.sql:3: ERROR:  relation "foo" already exists
psql:/opt/pgsql/share/extension/dblink.sql:4: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(0, a) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:5: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(1, b) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:6: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(2, c) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:7: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(3, d) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:8: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(4, e) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:9: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(5, f) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:10: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(6, g) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:11: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(7, h) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:12: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(8, i) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:13: ERROR:  duplicate key value violates unique constraint "foo_pkey"
DETAIL:  Key (f1, f2)=(9, j) already exists.
psql:/opt/pgsql/share/extension/dblink.sql:19: ERROR:  function dblink_get_pkey(unknown) does not exist
LINE 2: FROM dblink_get_pkey('foo');
             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
psql:/opt/pgsql/share/extension/dblink.sql:23: ERROR:  function dblink_build_sql_insert(unknown, unknown, integer, unknown, unknown) does not exist
LINE 1: SELECT dblink_build_sql_insert('foo','1 2',2,'{"0", "a"}','{...
               ^
HINT:  No function matches the given name and argument types. You might need to add ex