Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE EXTENSION dblink
- SELECT *
- FROM dblink('dbname=db_name2 port=5432
- host=xx.xx.x.x user=username_db2 password=password_db2',
- 'SELECT * FROM tableFrom_Db2');
- ERROR: a column definition list is required for functions returning "record"
- SELECT dblink_connect('host=xx.xx.x.x user=username_db2 password=password_db2 dbname=db_name2');
- ERROR: could not establish connection
- DETAIL: FATAL: no pg_hba.conf entry for host "IP_db1", user "username_db2", database "db_name2", SSL on
- FATAL: no pg_hba.conf entry for host "IP_db1", user "username_db2", database "db_name2", SSL off
Add Comment
Please, Sign In to add comment