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
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