Hello again, since we've had similar trouble without own server sockets, I had a deeper look into this one.
The trouble is that under AIX, once you have bound an IP V4 socket to a port, it seems you can't bind a IP V6 socket to the same port. The other way round works. And AIX seems to return addrinfo with IP V4 addresses in front. What I did is that I doubled the loop in pqcomm.c. In the first run, I only consider IP V6. In the second, I tried the rest. This worked, and I was able to connect to the IP V4 and the IP V6 address. Since it doesn't harm with other OSes to bind IP V6 first, does it seem to you like a sensible way of fixing this? Best regards, Curd Von: Curd Reinert/HH/PPI An: Curd Reinert/HH/PPI@PPI Datum: 27.02.2012 19:04 Betreff: Listening to * fails for IP V6 Hello everyone, on a AIX with IP V6 enabled, I try to listen on all interfaces listen_addresses = '*' and get LOG: could not bind IPv6 socket: Der Socket-Name wird bereits verwendet. HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. Of course I made sure there was nothing running on that port. I can then connect to the database using 127.0.0.1, but not with ::1. If instead I specify the IP addresses explictly, listen_addresses = '127.0.0.1,fdeb:df42:ebda:0815:0:0:0:18,::1' then there is no error and I can connect to all the addresses. 'localhost' instead of '*' also works, but I want to connect remotely. It's a 9.0.7 which was build on AIX 5.3 with readline, zlib and thread-safety disabled. The machine I originally tried to run it is a AIX 6.1. Symptoms on the 5.3 are the same. We only have this trouble on AIX. We are already connection succesfully remotely over IP V6 to database running on Linux, Solaris, and Windows 7 (as far as I know). I didn't find anything useful in FAQ or TODO, I hope I didn't miss something obvious. Many thanks, Curd
