After read this post from Mr. solaimurugan.v, I wanna add some detail only on creating dblink :

  1. First change your pg_hba.conf : host all all 127.0.0.1/32 trust…
  2. 47 more words