Re: pg_hba.conf issue

>From: Ritu Khetan <RKhetan(at)crisil(dot)com>
>To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>CC: pgsql-admin(at)postgresql(dot)org,pgsql-admin-owner(at)postgresql(dot)org
>Subject: Re: [ADMIN] pg_hba.conf issue
>Date: Tue, 3 Jul 2007 11:01:10 +0530
>
>What does ::1/128 signify?

Its the IPv6 notification to loopback address. In other words it is as good
as specifying 127.0.0.1 in IPv4.

>Regards,
>Ritu
>
>
>
>
> Tom Lane
> <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Sent by: To
> pgsql-admin-owner(at)postg Ritu Khetan
> resql.org <RKhetan(at)crisil(dot)com>
> cc
> pgsql-admin(at)postgresql(dot)org
> 02/07/2007 09:08 PM Subject
> Re: [ADMIN] pg_hba.conf issue
>
>
>
>
>
>
>
>
>
>
>Ritu Khetan <RKhetan(at)crisil(dot)com> writes:
> > # IPv4 local connections:
> > host all all 127.0.0.1/32 trust
> > # IPv6 local connections:
> > #host all all ::1/128 trust
> > #host all all 172.21.42.121/24 trust
> > host all all 172.21.51.56/24 trust
>
> > While this works at most of the locations, we have a peculiar error
>coming
> > up at 2-3 locations. The error reads:
>
> > no pg_hba.conf entry for host "::1" , user "crisil" , database "crisil"
>,
> > SSL off "
>
>No surprise: you have the IPv6 line commented out. Dunno why these
>particular boxes are preferring IPv6 to IPv4, maybe something different
>about the local DNS environment? Anyway, there is no point in refusing
>to serve ::1/128 if you're accepting 127.0.0.1.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>Disclaimer :
>This message (including any attachments) contains confidential information.
>If you are not the intended recipient, please delete the message (including
>any attachments) from your system without using, transmitting or storing
>it. Please also immediately inform the sender. E-mails are not secure and
>may suffer from errors, viruses, unauthorized interceptions / amendments.
>CRISIL and its subsidiaries do not accept any liability for loss or damage
>caused by this e-mail and may monitor e-mail traffic.
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

_________________________________________________________________
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507