Re: pg_hba.conf change in 7.4

Hi Bruce,

I tried to newly compiled 7.4 with HAVE_IPV6 commented out
in /src/include/pg_config.h.

After that I tried psql:

psql -U scncraft -h localhost
psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft",
database "A"

This happens the same way whether I have this line in pg_hba.conf or not:
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff:ffff:ffff:ffff:
ffff:ffff ident pspmap

Thanks.

Gan

At 8:48 am -0600 2003/12/7, Seum-Lim Gan wrote:
>Hi Bruce,
>
>I am rebuilding now and noticed some error that I may have missed
>since the last time I build 7.4.
>Essentially the postmaster, bin, lib have been built and server is able to
>start and I am able to create a new DB and etc.
>Will let you know if the commenting out the HAVE_IPV6 will work.
>
>Meanwhile, the following probably needs to be looked at.
>Some background: src/template/solaris has been changed to use -mt instead
>of -pthread. Built with Sun Workshop in Solaris 9.
>
>"pl_funcs.c", line 403: warning: argument #1 is incompatible with prototype:
> prototype: pointer to const unsigned char :
>"../../../../src/include/mb/
>pg_wchar.h", line 291
> argument : pointer to char
>UX tsort: INFORM: cycle in data
> pl_comp.o
> pl_gram.o
>"plperl.c", line 317: undefined symbol: thr
>"plperl.c", line 317: left operand of "->" must be pointer to struct/union
>"plperl.c", line 323: left operand of "->" must be pointer to struct/union
>"plperl.c", line 323: left operand of "->" must be pointer to struct/union
>"plperl.c", line 323: left operand of "->" must be pointer to struct/union
>"plperl.c", line 323: left operand of "->" must be pointer to struct/union
>"plperl.c", line 437: undefined symbol: thr
>"plperl.c", line 437: left operand of "->" must be pointer to struct/union
>"plperl.c", line 443: left operand of "->" must be pointer to struct/union
>"plperl.c", line 443: left operand of "->" must be pointer to struct/union
>"plperl.c", line 443: left operand of "->" must be pointer to struct/union
>"plperl.c", line 443: left operand of "->" must be pointer to struct/union
>cc: acomp failed for plperl.c
>make[3]: *** [plperl.o] Error 2
>make[2]: *** [all] Error 2
>make[1]: *** [all] Error 2
>
>
>>Yes, you have to comment it out like the other items in the file.
>>
>>---------------------------------------------------------------------------
>>
>>Seum-Lim Gan wrote:
>>> Hi Bruce,
>>>
>>> Thanks for the recommendation.
>>>
>>> I will edit the pg_config.h file and comment out the
>>> HAVE_IPV6 #define.
>>> It is now defined as 0.
>>>
>>> Earlier on, I tried to set IPV6 to no or 0 in configure.ih
>>> and then configure and rebuild but that did not work.
>>>
>>> Will let you know if commenting out the HAVE_IPV6 will work.
>>>
>>> Thanks.
>>>
>>> Gan
>>>
>>> At 11:28 am -0500 2003/12/6, Bruce Momjian wrote:
>>> >Seum-Lim Gan wrote:
>>> >> Hi Bruce,
>>> >>
>>> >> I wonder if there is any recommendation to this ?
>>> >> Is there a way to configure PostgreSQL to not use
>>> >> IPv6 ?
>>> >
>>> >One idea is to edit include/pg_config.h and comment out HAVE_IPV6 and
>>> >recompile and see if it works. That will disable the postmaster from
>>> >listening on IPv6.
>>> >
>>> >--
>>> > Bruce Momjian | http://candle.pha.pa.us
>>> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
>>> > + If your life is a hard drive, | 13 Roberts Road
>>> > + Christ can be your backup. | Newtown Square,
>>>Pennsylvania 19073
>>> >
>>> >---------------------------(end of broadcast)---------------------------
>>> >TIP 3: if posting/reading through Usenet, please send an appropriate
>>> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>> > message can get through to the mailing list cleanly
>>>
>>>
>>> --
>>> +--------------------------------------------------------+
>>> | Seum-Lim GAN email : slgan(at)lucent(dot)com |
>>> | Lucent Technologies |
>>> | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
>>> | Naperville, IL 60566, USA. fax : (630)-713-7272 |
>>> | web : http://inuweb.ih.lucent.com/~slgan |
>>> +--------------------------------------------------------+
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 8: explain analyze is your friend
>>>
>>
>>--
>> Bruce Momjian | http://candle.pha.pa.us
>> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
>> + If your life is a hard drive, | 13 Roberts Road
>> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
>
>--
>+--------------------------------------------------------+
>| Seum-Lim GAN email : slgan(at)lucent(dot)com |
>| Lucent Technologies |
>| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
>| Naperville, IL 60566, USA. fax : (630)-713-7272 |
>| web : http://inuweb.ih.lucent.com/~slgan |
>+--------------------------------------------------------+
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
+--------------------------------------------------------+
| Seum-Lim GAN email : slgan(at)lucent(dot)com |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+