Chris Browne wrote:
tgl@xxxxxxxxxxxxx (Tom Lane) writes:
Bill Kurland <bill@xxxxxxxxxxxxxxxxxxx> 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 ?
