How to connect the postgresql database automatically without password prompt ?

Following simple Two steps you can connect the postgresql database automatically without any password prompt

Step 1. create the bash_profile:

[root@2ndquadrant.in]# cat .bash_profile
export PGPASSWORD="tcs@12345"
export PGHOST="10.0.1.109"
export PGUSER="enterprisedb"
export PGPORT="5444"
/opt/edb/as9.6/bin/psql -d edb

Step 2. Run the bash_profile by using sh or . you will see the following postgres sql prompt

[root@2ndquadrant.in]# sh .bash_profile
psql.bin (9.6.2.7)
Type "help" for help.

edb=# \dt
            List of relations
 Schema |  Name   | Type  |    Owner
--------+---------+-------+--------------
 public | dept    | table | enterprisedb
 public | emp     | table | enterprisedb
 public | jobhist | table | enterprisedb
 public | test    | table | enterprisedb
(4 rows)