FATAL: no pg_hba.conf entry for host “::1”

Discussion in 'PostgreSQL' started by morny, Dec 5, 2009.

  1. morny

    morny New Member

    Joined:
    Dec 5, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    Im using an application that connects to postgreSQL, now its being tested on a few machines and connects fine but on 1 machine i get this FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “myDatabase", SSL off.

    Heres the HBACONFIG FILE DETAILS
    # TYPE DATABASE USER CIDR-ADDRESS METHOD

    # IPv4 local connections:
    host all all 127.0.0.1/32 md5
    # IPv6 local connections:
    #host all all ::1/128 md5

    So the issue seems to be with the last line on IPv6, to be honest i dont even know what IPv6 is, could disabling IPv6 do the trick or do i need to add something?

    The funny thing is with the exact same details a different application connects to postgreSQL fine? Any ideas and bare in mind im a newbie when explaining
     
  2. stephen186

    stephen186 New Member

    Joined:
    Feb 17, 2009
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    0

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice