[GENERAL] AIX and ipv6

2012-09-11 Thread John R Pierce
we're still having issues with PG on AIX 6.1, our configurations have no ipv6 as our WAN is purely ipv4, but if we use listen_addresses='*', we consistently get an error... LOG: could not bind IPv6 socket: Address already in use the workaround we've been using is to set listen_addresses

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread Tom Lane
John R Pierce pie...@hogranch.com writes: we're still having issues with PG on AIX 6.1, our configurations have no ipv6 as our WAN is purely ipv4, but if we use listen_addresses='*', we consistently get an error... LOG: could not bind IPv6 socket: Address already in use This was

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread Adrian Klaver
On 09/11/2012 09:09 AM, John R Pierce wrote: we're still having issues with PG on AIX 6.1, our configurations have no ipv6 as our WAN is purely ipv4, but if we use listen_addresses='*', we consistently get an error... LOG: could not bind IPv6 socket: Address already in use the

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread John R Pierce
On 09/11/12 10:12 AM, Adrian Klaver wrote: Did not say what version you where on. But in 9.1: http://www.postgresql.org/docs/9.1/interactive/runtime-config-connection.html The special entry * corresponds to all available IP interfaces. The entry 0.0.0.0 allows listening for all IPv4 addresses

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread Andrew Sullivan
On Tue, Sep 11, 2012 at 09:09:22AM -0700, John R Pierce wrote: is their any chance this will ever be addressed? The problem you're having is that * means bind to all the addresses on this machine, and for some reason IBM's strange and wonderful implementation of the IP layer appears to give

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread Merlin Moncure
On Tue, Sep 11, 2012 at 11:09 AM, John R Pierce pie...@hogranch.com wrote: we're still having issues with PG on AIX 6.1, our configurations have no ipv6 as our WAN is purely ipv4, but if we use listen_addresses='*', we consistently get an error... LOG: could not bind IPv6 socket: Address

Re: [GENERAL] AIX and ipv6

2012-09-11 Thread John R Pierce
On 09/11/12 12:55 PM, Merlin Moncure wrote: is their any chance this will ever be addressed? have you got your aix completely up to date with all patches? I got burned in a similar fashion a while back on a related call -- getaddrinfo IIRC. It was updated to 'current' a year or so ago, I