Basically follow this link will work. To give access of remote users using postgresql-client, one need to add the following line in /etc/postgresql/9.3/main/pg_hba.conf. host all all 0.0.0.0/0 md5
Setup the password for user
postgres
.Change the above line to:
and
sudo -u postgres psql
and