I have two PostgreSQL servers:
server 1: 192.168.0.1 server 2: 192.168.0.2
I want to connect to the database on server 2 from server 1. I do it like this:
SELECT dblink_connect('hostaddr=192.168.0.2 port=5432 dbname=mydb user=postgres password=mypasswd');
My question is that when I do such connect my password is send as plaintext or its somehow encrypted during the transmission to the server 2?
I use PostgreSQL 9.3 on Linuxx Mint 16 (server 1) and Xubuntu 13.10 (server 2).