Guest User

Untitled

a guest
Feb 18th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. CREATE EXTENSION dblink
  2.  
  3. SELECT *
  4. FROM dblink('dbname=db_name2 port=5432
  5. host=xx.xx.x.x user=username_db2 password=password_db2',
  6. 'SELECT * FROM tableFrom_Db2');
  7.  
  8. ERROR: a column definition list is required for functions returning "record"
  9.  
  10. SELECT dblink_connect('host=xx.xx.x.x user=username_db2 password=password_db2 dbname=db_name2');
  11.  
  12. ERROR: could not establish connection
  13. DETAIL: FATAL: no pg_hba.conf entry for host "IP_db1", user "username_db2", database "db_name2", SSL on
  14. 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