PostgreSQL Error

Issue : Unable to connect to PostgreSQL server

Error :
Warning: pg_connect (): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host ":: 1", user "username_root" database "username_coop", SSL off in / home / username/ public_html /

Solution.

Edit the PostgreSQL file /var/lib/pgsql/data/pg_hba.conf and add ipv6 lines as shown below (enable ipv6)

host    all         all         ::1/128               md5

Restart PostgreSQL  service and check your connection.