I resolved this issue using below options:
- Whitelist your DB host from your network team to make sure you have access to remote host
- Install postgreSQL version 4 or above
- Run below command:
psql -h <REMOTE HOST> -p <REMOTE PORT> -U <DB_USER> <DB_NAME>