![]() It should be bundled as an extension in 9.1 dblink.sql is not present after postgresql-contrib install Will allow non-superusers to connect using any authentication method.įor Superuser ask them to create extension CREATE EXTENSION dblink įor your database or schema. Just give the name of database u want to connect after dbnameĭblink_connect_u() is identical to dblink_connect(), except that it SELECT dblink_connect('myconn', 'hostaddr=remote_addr port=9000 dbname=production user=user password=passwd') Just run this command below whether you are able to connect to database SELECT dblink_connect('myconn', 'dbname=postgres') Yes only superuser can provide you to the facility to connect through DBLINK Postgres: Using dblink to make remote connection ![]() It looks like exactly what I get if dblink is installed in "public" but "public" is not in my search_path. ![]() Source: Using dblink extension from pg-promise DbLink is located in share/contribs/dblink.sql of your PostgreSQL install.To use it, load the dblink.sql file in the database you would like to use it in.
0 Comments
Leave a Reply. |