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