Re: AIX and getaddrinfo

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

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.
--
let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;;
http://linuxfinances.info/info/linux.html
Rules of the Evil Overlord #131. "I will never place the key to a cell
just out of a prisoner's reach." <http://www.eviloverlord.com/>