November 29th, 2012, 08:29 AM
Join Date: Nov 2012
Time spent in forums: 11 m 15 sec
Reputation Power: 0
No pg_hba.conf entry for host "::1"
When using command: "createuser --createdb --username postgres --no-createrole --pwprompt openpg" I am getting the following error:
createuser: could not connect to database postgres: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL off
PostgreSQL is installed on local machine Windows 7 and I am trying to command on the same local machine
Here is my pg_hba.conf:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
Could anyone help? Thanks very much.