1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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