| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Manohar Bhattarai <manoharbhattarai(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: configure same pg_hba.conf file for both ipv4 and ipv6 network |
| Date: | 2011-12-14 10:25:12 |
| Message-ID: | CAD2md3HtzGXScxk_6sUjd1SUVEXwoccB4cSc6HFKA7Ek+csMcg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Dec 14, 2011 3:59 PM, "Manohar Bhattarai" <manoharbhattarai(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sylvain Mougenot | 2011-12-14 13:29:39 | JDBC Statement.setQueryTimeout : is there plan to implement this? |
| Previous Message | Manohar Bhattarai | 2011-12-14 07:58:10 | configure same pg_hba.conf file for both ipv4 and ipv6 network |