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