Re: AIX and getaddrinfo

Chris Browne wrote:
> tgl@sss.pgh.pa.us (Tom Lane) writes:
>
>> Bill Kurland <bill@shakespeare-nyc.com> writes:
>>
>>> I did a google search on AIX + getaddrinfo and found
>>> http://lists.samba.org/archive/rsync/2002-April/002063.html
>>> In that context the author says that adding the port number in
>>> etc/services solved his problem with getaddrinfo.
>>>
>> Interesting.  I wonder whether IBM thinks that there is some
>> security-related reason for only allowing programs to bind to port
>> numbers that are listed in /etc/services?
>>
>>
>>> So I tried that and,
>>> lo, it has some effect, though I'm not sure it's 100% desirable. The log
>>> entry is:
>>>
>>> LOG:  could not bind IPv6 socket: The type of socket is not supported in
>>> this protocol family.
>>> HINT:  Is another postmaster already running on port 5432? If not, wait
>>> a few seconds and retry.
>>>
>> I think this is OK.  There are many machines on which the userspace
>> code supports IPv6 while the kernel doesn't, or vice versa.  It looks
>> to me like getaddrinfo returned both IPv4 and IPv6 translations of
>> "localhost", but the kernel rejected the IPv6 version when PG tried it.
>> Since you evidently have a working IPv4 port, there's nothing to worry
>> about.  If it really bugs you, the /etc/netsvc.conf change suggested in
>> our FAQ_AIX would probably suppress the log message.
>>
>> Can anyone else confirm the behavior of getaddrinfo wanting port 5432
>> to be listed in /etc/services?  If this is real, we ought to have
>> something about it in FAQ_AIX.
>>
>
> That doesn't make a lot of sense to me...
>
> It is fair to say that AIX does include a PostgreSQL entry, by
> default:
>
> pgorg@nj-570-db4011:/opt/home/pgorg $ grep 5432 /etc/services
> postgresql              5432/tcp                # PostgreSQL Database
> postgresql              5432/udp                # PostgreSQL Database
>
> [We didn't add these entries ourselves; they were there by default.]
>
Odd. I checked 4 different AIX 4.3 machines and none of them have
postgresql entries. I don't have
any AIX 5 boxes. Is that what you are running?
> But most of our database backends run on ports other than 5432, and I
> haven't noticed anything that seems to tie to that.  We have had
> difficulties with getaddrinfo(), but I don't think there's anything
> that hasn't either been resolved in modern PG releases or listed in
> FAQ_AIX.
>
I just reread the FAQ_AIX doc for 8.1.5 and I couldn't find any
reference to getaddrinfo. What difficulties
have you seen and under which AIX ?