AIX FAQ - IPv6 Fun
cbbrowne@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@~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
Import Notes
Reference msg id not found:
Applied.
---------------------------------------------------------------------------
Chris Browne wrote:
cbbrowne@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@~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---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +