#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2008
    Posts
    30
    Rep Power
    6

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


    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Oct 2004
    Location
    Birmingham, UK
    Posts
    722
    Rep Power
    42
    http://forums.devshed.com/postgresql-help-21/
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2008
    Posts
    30
    Rep Power
    6
    Should i repost it there or wait for a mod to move it, i did actually look but missed that there was a postgresql section, sorry
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    Originally Posted by morny
    # IPv6 local connections:
    #host all all ::1/128 md5

    So the issue seems to be with the last line on IPv6
    That line is commented, so it is not active.
    Remove the # at the beginning...

IMN logo majestic logo threadwatch logo seochat tools logo