Unable to Connect to the Postgres SQL Database from Command Prompt

Unable to Connect to the Postgres SQL Database from Command Prompt

Issue :
Unable to Connect to the Postgres SQL Database from Command Prompt

Error :



Analysis :
IPv6 local connections are commented in <AnalyticsPlus home>\pgsql\data\pg_hba.conf file

Solution :
Open the file using notepad or wordpad as administrator and edit as below.

Original Entry
# IPv6 local connections:
#host    all             all             ::1/128                 trust 

Modified Entry
# IPv6 local connections:
host    all             all             ::1/128                 trust 


                  New to ADSelfService Plus?