pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vishal Arora <aroravishal22@hotmail.com>
To: RKhetan@crisil.com
To: tgl@sss.pgh.pa.us
Cc: pgsql-admin@postgresql.org
Cc: pgsql-admin-owner@postgresql.org
Subject: Re: pg_hba.conf issue
Date: Tue, 03 Jul 2007 06:59:11 +0000
Message-ID: <BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl> (raw)
In-Reply-To: <OF5610B2A3.54EF8BA5-ON6525730D.001E4848-6525730D.001E8293@crisinfac.com>




>From: Ritu Khetan <RKhetan@crisil.com>
>To: Tom Lane <tgl@sss.pgh.pa.us>
>CC: pgsql-admin@postgresql.org,pgsql-admin-owner@postgresql.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@sss.pgh.pa.us>
>                             Sent by:                                    To
>              pgsql-admin-owner@postg         Ritu Khetan
>                            resql.org         <RKhetan@crisil.com>
>                                                                         cc
>                                              pgsql-admin@postgresql.org
>                  02/07/2007 09:08 PM                               Subject
>                                              Re: [ADMIN] pg_hba.conf issue
>
>
>
>
>
>
>
>
>
>
>Ritu Khetan <RKhetan@crisil.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




view thread (12+ messages)  latest in thread

Message-ID: <BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl>
Permalink:  ../BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: aroravishal22@hotmail.com, RKhetan@crisil.com, tgl@sss.pgh.pa.us, pgsql-admin-owner@postgresql.org
  Subject: Re: pg_hba.conf issue
  In-Reply-To: <BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl>
  References: <OF5610B2A3.54EF8BA5-ON6525730D.001E4848-6525730D.001E8293@crisinfac.com> <BAY123-F33CECE99463A561D9D0C18A90C0@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox