Skip site navigation (1) Skip section navigation (2)

AIX FAQ - IPv6 Fun

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: AIX FAQ - IPv6 Fun
Date: 2006-05-25 21:07:25
Message-ID: 6064jt6cfm.fsf_-_@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-patches
cbbrowne(at)dba2:/opt/OXRS/sources/pgsql-HEAD/doc$ cvs diff -u FAQ_AIX 
Index: FAQ_AIX
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/FAQ_AIX,v
retrieving revision 1.17
diff -c -u -r1.17 FAQ_AIX
cvs diff: conflicting specifications of output style
--- FAQ_AIX	13 Apr 2006 11:41:02 -0000	1.17
+++ FAQ_AIX	25 May 2006 21:06:21 -0000
@@ -365,3 +365,35 @@
   IBM Redbook
   http://www.redbooks.ibm.com/redbooks/pdfs/sg245674.pdf
   http://www.redbooks.ibm.com/abstracts/sg245674.html?Open
+
+
+Statistics Collector Fun on AIX
+--------------------------------
+
+When implementing PostgreSQL version 8.1 on AIX 5.3, we periodically
+ran into problems where the statistics collector would "mysteriously"
+not come up successfully.
+
+This appears to be the result of unexpected behaviour in the IPv6
+implementation.  It looks like PostgreSQL and IPv6 do not play very
+well together at this time on AIX.
+
+Any of the following actions "fix" the problem.
+
+1.  Delete the localhost ipv6 address
+
+(as root)
+# ifconfig lo0 inet6 ::1/0 delete
+
+2.  Remove IPv6 from net services.  The file /etc/netsvc.conf, on AIX,
+is roughly equivalent to /etc/nsswitch.conf on Solaris/Linux.
+
+The default, on AIX, is thus:
+
+  hosts=local,bind
+
+Replace this with:
+
+  hosts=local4,bind4
+
+to deactivate searching for IPv6 addresses.
\ No newline at end of file

-- 
(format nil "~S(at)~S" "cbbrowne" "cbbrowne.com")
http://cbbrowne.com/info/finances.html
"I once witnessed  a long-winded, month-long flamewar over  the use of
mice vs. trackballs...It was very silly." -- Matt Welsh

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-05-25 22:16:30
Subject: Cleanup for new escape handling
Previous:From: Greg Sabino MullaneDate: 2006-05-25 16:06:12
Subject: Re: plperl - put schema-name in $_TD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group