I created new database called "shashi" in PgAdmin III. In QGIS to create new connection I entered following details.
In PostgreSQL 9.5 pgAdmin lll Please enter password for user postgres on server PostgreSQL 9.5: ****
In QGIS Create a New PostGIS Connection Name: shashidhar Service: Host: localhost Port: 5432 Database: postgres SSL mode: disable
Authentication Username: postgres Password: **** (same password that I used in pgAdmin lll to connect to the server )
Test connection ERROR: Connection failed-consult message log for details