Re: configure same pg_hba.conf file for both ipv4 and ipv6 network - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: configure same pg_hba.conf file for both ipv4 and ipv6 network
Date
Msg-id CAD2md3HtzGXScxk_6sUjd1SUVEXwoccB4cSc6HFKA7Ek+csMcg@mail.gmail.com
Whole thread Raw
In response to configure same pg_hba.conf file for both ipv4 and ipv6 network  (Manohar Bhattarai <manoharbhattarai@gmail.com>)
List pgsql-jdbc


On Dec 14, 2011 3:59 PM, "Manohar Bhattarai" <manoharbhattarai@gmail.com> wrote:
>
> Hi,
>
>  I want to configure the pg_hba.conf for a network in which we have both ipv4 and ipv6 machines. How can I use a single pg_hba.conf file for that network?
> Current ipv6 setting is :
>
> # IPv6 local connections:
>
>
>
> host    testpc         all         ::1/128               trust

Add another line for IPv4 connections that uses

127.0.0.1 255.0.0.0

to specify the address and mask.

>
>
> The error its giving in log file is:
>
> Dec 14 07:53:10 support-desktop postgres[25448]: [2-1] LOG:  connection received: host=127.0.0.1 port=XXXXX
> Dec 14 07:53:10 support-desktop postgres[25448]: [3-1] FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "XXXX", database "XXXX", SSL off
>
> Please help me set this configuration.
>
> --
> Regards,
> Manohar Bhattarai (मनोहर भट्टराई)
> http://about.me/manoharbhattarai
> http://www.facebook.com/pages/Manohar-Bhattarai/130973796914160
> Blogs:
> http://manoharbhattarai.wordpress.com/
> Microblogs:
> Twitter :- http://twitter.com/mhrbhattarai
> Identi.ca :- http://identi.ca/manoharbhattarai

pgsql-jdbc by date:

Previous
From: Manohar Bhattarai
Date:
Subject: configure same pg_hba.conf file for both ipv4 and ipv6 network
Next
From: Craig Ringer
Date:
Subject: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?