Chris Browne wrote:
> tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) writes:
>
>> Bill Kurland <bill(at)shakespeare-nyc(dot)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(at)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 ?